Mod Edit: Follow-up to this thread
Please start a new thread for new questions, rather than 'hijacking' an old one (especially one almost a year old)
-------------------
If i want to add the tab (worksheet name) to copy from how can i do so? all of the files that I need consolidated have conisistent tab names. For example, if I have 30 workbooks and each have the tab called "sheet 2," I need the data only from that tab. Thanks in advance.
Aman
Please start a new thread for new questions, rather than 'hijacking' an old one (especially one almost a year old)
-------------------
If i want to add the tab (worksheet name) to copy from how can i do so? all of the files that I need consolidated have conisistent tab names. For example, if I have 30 workbooks and each have the tab called "sheet 2," I need the data only from that tab. Thanks in advance.
Aman