Have data export automatically from sheet1 to sheet 2?

Hi. I have data entered on excel - which I sort by date. I want the entries that are 10 days overdue to be exported to a seperate excel spreadsheet - lets call it sheet2.

Is it possible that something like this can be setup to happen automatically?

If so, how do I go about it?

Originally Posted by Domski

Hi,

When you say automatically would at the click of a button be okay or do you want it to update each time you open the workbook/select the worksheet etc?

Dom

Hi Dom - thanks for your response. I guess automatically would be better ie. expiry date - greater than ten days - and it automatically is transferred across to sheet 2.

If this is not possible, I guess at the click of the button will do.