Hello all, I am relatively new to Excel, and this problem likely has a simple answer, but I just can't find it. So here goes:
I have a master list that has about 10,000 rows, where column A is the "name" and columns b through p contains data (each row has a different name). I have another list that has about 5000 rows, where column A is the names and are a subset of the names in the master list. What I want to do is get the data from columns b through p from the master list for the 5000 rows in the subset list. I have zero experience with VBA, and very little experience with excel.
Any help is greatly appreciated.
Thanks so much,
AG