Matching up data from different workbooks

Lark

New member
Joined
Dec 10, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Excel for Mac 16.43
I think what I want to do is simple for folks who are experienced, but I am a VBA noob. I want to match up ID numbers in two different workbooks, and copy over the "College" info from "IDs and Colleges" over to column B of "IDs with duplicates" where the ID numbers match, including duplicate info when necessary. Can you help me?

Thanks!!

View attachment IDs and colleges.xlsm
View attachment IDs with duplicates.xlsm
 
Never mind!! after extensive Googling I found the right snippet of code and figured it out! Nothing to see here, lol.
 
Back
Top