I have a macro that is opening several spreadsheets, pulling data out and pasting it into a new spreadsheet. The problem is that the tab that I am pulling from has a different name and location in each spreadsheet that I am opening. My question is, I know that I can tell the macro to prompt me as what spreadsheet to open, but can I prompt the tab also??
Or, each spreadsheet that I am opening to pull data from, while all the tabs have different names, but they have the same three letters at the end of the tab name (UPL), can I wildcard it and tell the macro to look and pull from any spreadsheet containing the letters UPL ??
I'm stumped....Any advice would be appreciated! thanks!
Or, each spreadsheet that I am opening to pull data from, while all the tabs have different names, but they have the same three letters at the end of the tab name (UPL), can I wildcard it and tell the macro to look and pull from any spreadsheet containing the letters UPL ??
I'm stumped....Any advice would be appreciated! thanks!