code not to copy formula

[peter renton]

Hi All

Can somebody help me with this

i have a code in sheet 2 that when a y is entered into column m it copies that row into sheet 3
but it also copies the formula aswell,
In sheet 1 the data will be auto deleted when a date is reached but this would also delete the data in
sheet 3 because its still looking at the formula, how can i get araound this?

The data in sheet 2 is just mirrored from sheet 1 which when the data in sheet 1 is deleted would leave
blank rows in sheet 2 is there a way around this to ??


Any help would be appreciated

Peter