Compare Column C Workbook A with Workbook B, Column C across multipal Worksheets

[GatorsBucs]

I’m lost. I haven’t been able to locate a thread that could help me with this. Any help would be greatly appreciated.
I have two workbooks. Workbook A has a list of numbers in column C of Sheet1. Workbook B has these same numbers in column C but spread over different worksheets (Feb through June). What I need to do is create a macro that will go through the list of numbers in Workbook A column C and locate which worksheet it resides in, in workbook B and put the name of the worksheet / month in Workbook A in column G in the same row as the corresponding number. (I have put the name of each worksheet in column I row 1 of each worksheet so a copy and paste would work) I have attached an example.
Thanks again!

[McNitz]

Here's a short macro that should do what you want. If you are going to have a different name for workbook B then you will have to change that in the macro. Also, you will have to have both workbooks open in the same instance of excel, this won't open up workbook B by itself. Otherwise it should work perfectly for you!

Please Login or Register  to view this content.

[GatorsBucs]

Thank you McNitz. This worked perfectly!!