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