copy data from multi tabs of multiple files to one file with res Closed

Question

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.

 NOTE:
 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.


 Required:

 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.

 Thanks and regards,
 Mahesh

rizvisa1 · Answer

Pivot may cause issue. However you can get some idea from 
https://ccm.net/faq/29984-excel-merge-several-worksheets-into-a-single-one
this combine same sheet into one sheet. it can be modified to copy various sheet into same name sheet. But as I said, pivot table is open question. If start of row/column and end of same can be identified then life is good

molletica · Answer

Thank u for coming back, I have no idea of writing  programming, need further help on this.

molletica · Answer

Hi,

one more common i have noted in all the tabs is at the end of each raw data and before Pivot starts there is a word saying don't delete will be updated in all the tabs of the sheet.

Copy data from multi tabs of multiple files to one file with res

3 responses

Similar discussions

Subscribe To Our Newsletter!