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

Report
Posts
4
Registration date
Saturday November 15, 2014
Status
Member
Last seen
November 19, 2014
-
Posts
4
Registration date
Saturday November 15, 2014
Status
Member
Last seen
November 19, 2014
-
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

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
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
Posts
4
Registration date
Saturday November 15, 2014
Status
Member
Last seen
November 19, 2014

Thank u for coming back, I have no idea of writing programming, need further help on this.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
I think if you post a sample workbook that would help
Posts
4
Registration date
Saturday November 15, 2014
Status
Member
Last seen
November 19, 2014

Not able to attach files..
Posts
4
Registration date
Saturday November 15, 2014
Status
Member
Last seen
November 19, 2014

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!