I'm not a newbie to excel, but don't have any experience with programming or macros. I have three spreadsheets for different areas (all in one file) that I would like to have auto-populate a fourth spreadsheet without me having to copy and paste manually. I have tried a [=Sheet1!A6] type formula, but the items listed in each of the first three spreadsheets are listed by date and as these dates pass, I delete the whole row. This results in errors on the final spreadsheet.
To complicate matters, as each row starts with a date, I would like all the items to populate the fourth spreadsheet in date-order. If this is not possible, I will settle for my first need and simply sort the final page.
Can anyone help please?
Thanks
Bookmarks