Im not sure whether this is the correct term for what im trying to do
I have a large spreadsheet and i need to consolidate the data contained within 2 of the worksheets so that they drop into another sheet (ie the 2 sets of data sitting underneath each other)
For example sheet1 has 1000 rows of data which is copied and pasted in from a csv file (however, the amount of data rows in the csv file changes from week to week)
Sheet 2 has 250 rows of data all columns/headers etc are the same but this is inputted manually.
I want sheet 3 to automatically update so that it takes the data in sheet 1 and sheet 2 - so i have 1250 rows of data - this in itself is not a problem.
However i want sheet 3 to recognise when the rows of data increase or decrease in sheet 1 or 2
so next week for example when i clear the data in Sheets 1 and 2 and paste in the updated data - there could be 1300 rows in sheet 1 and 300 rows in sheet 2
i then want sheet 3 to contain those 1600 rows of data. - I always want the manually inputted rows of data in sheet 2 to jump directly below the newly copied in data from
I suspect i haven't explained myself very well
I have a large spreadsheet and i need to consolidate the data contained within 2 of the worksheets so that they drop into another sheet (ie the 2 sets of data sitting underneath each other)
For example sheet1 has 1000 rows of data which is copied and pasted in from a csv file (however, the amount of data rows in the csv file changes from week to week)
Sheet 2 has 250 rows of data all columns/headers etc are the same but this is inputted manually.
I want sheet 3 to automatically update so that it takes the data in sheet 1 and sheet 2 - so i have 1250 rows of data - this in itself is not a problem.
However i want sheet 3 to recognise when the rows of data increase or decrease in sheet 1 or 2
so next week for example when i clear the data in Sheets 1 and 2 and paste in the updated data - there could be 1300 rows in sheet 1 and 300 rows in sheet 2
i then want sheet 3 to contain those 1600 rows of data. - I always want the manually inputted rows of data in sheet 2 to jump directly below the newly copied in data from
I suspect i haven't explained myself very well