Copy Sheets 2-5 from several worbbooks

H

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,570
Office Version
  1. 2021
Platform
  1. Windows
I have 5 workbooks where I want to copy the data from sheets 2-5 for same row header (which are in row 4) one below the other where the row headers are the same for eg Sales Shirts must all be copied one below the other where the row header in row 4 contains the same header for eg Sale Shirts, sale trousers etc


I want the info to be copied on to from sheet 2 onto sheet1 , sheet 3 on to sheet 2 from etc on row 1 onwards on the destination workbook



Your assistance in this regard is most appreciated
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
You must log in or register to reply here.

Similar threads

Kaz09
  • Question
Copy rows from multiple sheets based on data
Replies
1
Views
310
Fluff
Fluff
G
  • Question
Copy specific columns from multiple sheets to another sheet
Replies
8
Views
458
Joe4
Joe4
F
  • Question
Copy to Multiple Worksheets With Different Arranged Headers ROW by ROW
Replies
1
Views
150
Cubist
Cubist
H
  • Solved
Macro to Copy Data from Sheet BR1 Shirt Sales to Last Sheet
Replies
9
Views
573
kevin9999
K
A
  • Question
Formula to copy data from 3 sheets out of 5 and copy one after another in new sheet
Replies
1
Views
104
etaf
etaf

Forum statistics

Threads
1,216,572
Messages
6,131,488
Members
449,653
Latest member
aurelius33

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