Combining worksheets from multiple workbooks into a single worksheet in a NEW workbook

E

excel4use

New Member
Joined
Sep 6, 2014
Messages
1
I have with me tens of workbooks with me in a folder.
Each workbook has 3 sheets; however the data which I'm bothered about is in Sheet 1 for every workbook.

For each workbook, Sheet 1 data:

  • consists of fixed number of columns but variable number of rows (some of them having 35000 rows).
  • have fixed column headers in the first row.


I have a blank Master Sheet saved in the same folder mentioned above. I want to combine all the data from Sheet 1 of all the workbooks to Sheet 1 of the Master Sheet. First row of the Master Sheet should be the column header and combined data should start from second row.

Can someone help me with a macro to get the above job done.

Regards.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

S
  • Question
Copy certain column N number of times
Replies
0
Views
170
sm789
S
A
  • Question
populate data based on Matching headers for multiple sheets across files
Replies
0
Views
114
Amer Omar
A
F
  • Question
Copy to Multiple Worksheets With Different Arranged Headers ROW by ROW
Replies
1
Views
358
Cubist
Cubist
M
  • Question
Excel Avg Multiple Workbooks
Replies
1
Views
86
MikeCritt
M
L
  • Solved
Macro to open multiple workbooks and copy a range of data based on todays date. Then paste the data in master workbook in one sheet under each other.
Replies
8
Views
486
Luke1690
L

Forum statistics

Threads
1,221,522
Messages
6,160,311
Members
451,637
Latest member
hvp2262

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top