Need help in copying data from multiple files. Below is the situation.
1. I have total 70 identical file with different data in that.
2. All 70 files as 5 tabs with data filled in that.
3. Untill now I am opening each file and copying the data from each tab of the file to a separate file.
In the data tab along with the data a pivot also available, I don't want the Pvt to be copied. I want only data from those sheets.
All the 70 files has tab called x1,X2,X3,X4.
Now I want the data from above tabs of all th 70 file should be copied in new file (one file). All the data from X1, tab of 70 files should be copied in X1 tab of the new file, similarly for the data from other tabs.
The issue is this a time consuming.
Need help in making my life easy.
Hope I have give enough information, please email me for any further clarifications.