I think I would bring the data into Access as separate tables (either import
or linked tables). Then build a query joining the two tables on the column
you speak of.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"taiwansmith" wrote:
| 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