copying from several into one sheet

Corleone

Well-known Member
Joined
Feb 2, 2003
Messages
841
Office Version
  1. 365
i have been messing around with this for a while to no avail

i have a spreadsheet with a number of tabs in it lets call them

sheet1
sheet2
sheet3
sheet4

which all have records entered in them each record contains data in columns
H TO Col AB - Starting at row 4 (row 3 contains the titles)

from week to week the amount of records in sheets 1-4 will vary and in some cases, there will be no records at all.

i am trying to automate the process so that it copies the data from each of the sheets 1 - 4
and pastes it into sheet 5

before the process runs, all the rows from 4 downwards in sheet 5 get cleared.

It then goes to sheet 1, selects the range of data, copies and pastes the records into sheet 5 (row 4 column h)
then looks up sheet 2, selects the range of data, goes into sheet 5, goes to the next empty row below the previously copied data and pastes the next selection, and so on.
 

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).

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

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