|I have two spreadsheets. Sheet 1 has a list of names in Column A, and information in Column B (text and numerical) that corresponds with the name of the same row.|
e.g. "Bob" corresponds with the information in Column C.
A B C D
The second spreadsheet has a long list of names (in no particular order) in a single column. I would like the macro to search the 1st sheet for every name on the list in the 2nd sheet, and copy the information specified from 1st sheet and paste it into the 2nd sheet.
So, if the 2nd sheet had "Bob" first on its list, it would search the 1st sheet for "Bob" until it found it, and copy "123" into the corresponding cell on the 2nd sheet. It would then go to the next name on the 2nd sheet, and continue until the end of the list.
Basically, I am stuck manually searching for each name, copying the information, and pasting it into the 2nd sheet. I have hundreds of names, so this is painstaking.
Any help would be greatly appreciated, thanks!