Hi

In the last wb test 2222 there is a formula to mirror dats from sheet1 into sheet 2 is there a way i can get it to enter the data in the first available row with
a blank cell in column a?

The data in sheet 2 will get auto deleted when the contract expires so will leave blank rows dotted around


Any Help would be appreciated