combining workbooks into one sheet

P

p4nny

Board Regular
Joined
Jan 13, 2015
Messages
246
Hi

I would to combine multiple workbooks into one sheet that loops through a specified folder.

The only requirement would that it copies from row 6 down to the last row.

Would appreciate some help
Many thanks
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

W
  • Question Question
[Excel 365] Maximizing unique combinations of words - No repeats between any two words
Replies
4
Views
323
waffle
W
C
  • Question Question
Finding all combinations to a summed value
Replies
9
Views
289
cerberus1845
C
S
  • Question Question
Suggestions on how to compile two sheets into one using unique values
Replies
2
Views
192
kvsrinivasamurthy
K
B
  • Question Question
Use INDIRECT combined with INDEX MATCH (multiple row criteria) to return values from specified sheet
Replies
4
Views
547
Peter_SSs
Peter_SSs
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
710
Micron
M

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

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