Can anyone help me with creating code that at startup of an excel file, that will
go to my 'ChartInfo' spreadsheet;
sort the date column (column A);
remove the dates that are more than a year old; and
paste the dates to another spreadsheet called 'OldData'.
When pasting, I don't want the data on the sheet removed so I need the code to find the next blank row and paste the dates there.
Thanks for your help and time in advance!
Sadie
go to my 'ChartInfo' spreadsheet;
sort the date column (column A);
remove the dates that are more than a year old; and
paste the dates to another spreadsheet called 'OldData'.
When pasting, I don't want the data on the sheet removed so I need the code to find the next blank row and paste the dates there.
Thanks for your help and time in advance!
Sadie