Hi everyone,
I have 3 workbooks with multiple worksheets. Workbook1, Workbook2, Workbook3
All three workbooks can be open at the same time
I have a list of worksheet names found in Master_Workbook column A1
What I'm trying to do is have a macro which will loop through the list of worksheet names in Master_Workbook column A1, and look through all three workbooks. If at least two workbooks have a worksheet with the same name, it will merge to the two (or three) into a new workbook with the same name.
I've been doing some research on this but I haven't been able to find anything quite like this.
Any ideas?
Thanks!!
Bookmarks