Idiot's Guide to Extracting Specific Text From Excel File – and Placing on Clipboard?

[ALYB]

If it would be okay for you to save the records as tab-del text instead of in an Excel table, you could get some inspiration here:

Ultimate Term Tool

With this macro you can easily add term pairs to a tab-delimited text file (that can be opened, sorted etc. with Excel etc.). Place the example file Terms.txt on your Desktop. Its structure matches the layout of the dialogue boxes in this macro. Select the entry –Add a new term pair to add a new term pair. Select the entry –Edit a term pair to activate editing of an existing term pair. (You have to enter/select the appropriate source term.) Or just type a source term, select the correct one an…

You could also copy the Excel table to clipboard first.