Have data export automatically from sheet1 to sheet 2?

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.