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

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