Hello! I've seen a similar question in the forums, but being not Excel-savvy, I can't figure out how to apply the solutions to my particular problem. I have data across workbooks that I need to copy from multiple workbooks into one master one. Basically, I need to search many workbooks for matching emails, and for those emails that match, copy values from specific columns into the master workbook. I have attached a shortened, anonymized version of what exactly I am working with: 1.2.comments.xls, 1.3.comments.xls, participation.xls.
So, specifically, I need to search column A of 1.2.comments.xls and 1.3.comments.xls for emails that match column A of participation.xls. For those emails that match, I want to copy column D of 1.2.comments.xls into column D of participation.xls, and column D of 1.3.comments.xls into column E of participation.xls.
Please let me know if any clarification is needed.
I need specific directions about how to go about applying any help you may give me, and also a bit about how I modify to meet other needs and the larger data file I actually have.
My apologies if this goes somewhere else, I couldn't tell what specific type of thing (ie, macro, etc) I needed.
Lastly, I need this to work in both excel 2003 and excel 2010.
Thanks so much!!
Bookmarks