I have a workbook titled “data comparison” that contains sample i
numbers in column B ( example: Sample1, Sample10, sample32 etc.).
I would like to write code that opens a second workbook title
“results”, searches column A of that workbook for the matching sampl
ID (ex. Sample32), then copies data in the row with the matching sampl
ID and pastes the data back into the first workbook (data comparison).
Specifically, I am having trouble with the search method between tw
workbooks. Any tips would be helpful. Thank

--
Message posted from http://www.ExcelForum.com