Hi all,
I have to workbooks, one for our data and one from our source. Both workbooks have sheets that are numerically named 1 through 58 and other sheets that don't really matter to me. What I need to do is: If our data workbook is on sheet "1", I want to activate the source workbook and find sheet "1". And then do that from 1 to 58. I need this done by name though and not sheet sequence because sheet "1" is actually located on Sheet4. Does this make sense?
Bookmarks