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

Closed
molletica Posts 4 Registration date Saturday 15 November 2014 Status Member Last seen 19 November 2014 - 15 Nov 2014 à 03:33
molletica Posts 4 Registration date Saturday 15 November 2014 Status Member Last seen 19 November 2014 - 19 Nov 2014 à 22:58
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
Related:

3 responses

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Nov 2014 à 05:39
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 Posts 4 Registration date Saturday 15 November 2014 Status Member Last seen 19 November 2014
15 Nov 2014 à 07:17
Thank u for coming back, I have no idea of writing programming, need further help on this.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Nov 2014 à 18:57
I think if you post a sample workbook that would help
molletica Posts 4 Registration date Saturday 15 November 2014 Status Member Last seen 19 November 2014
19 Nov 2014 à 22:58
Not able to attach files..
molletica Posts 4 Registration date Saturday 15 November 2014 Status Member Last seen 19 November 2014
19 Nov 2014 à 22:54
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.