Hi,

use a Filter an Colum G set to "non blank cells", copy the whole range and
insert it in sheet 2. You can record a macro to see what's required for VBA.

arno


"Robert Couchman" schrieb im Newsbeitrag
...
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