I'm having trouble figuring out how to code a macro that will perform this
function:

-Extract text in a column of spreadsheet #1
-Look up that same text in a column of spreadsheet #2
-Either highlight it for later use and/or
-Copy data within the same row of spreadsheet #2, but a different column
associated with the extracted text from spreadsheet #1
-Return to spreadsheet #1 and paste the data extracted from #2 into the same
row, but a new column.

This is apart of a data mining exercise in a cancer research lab. It falls
under the realm s of bioinformatics, but since so many people here appear to
be expert, I figured I ought to start here.

Cheers,
taiwansmith