Hello,

here is a troublesum one,

i am looking for a piece of code that will look down
column G and if it finds a value in the cell (in this case
it will be a date), then it will copy the entire row and
paste it into sheet 2, then continue down sheet 1 till it
has reached the bottom.

any help anyone?

thank you,

Robert Couchman