Copy row with data to second sheet

[shy07014]

hi there,
i need help with a bit of code:

i need to have a macro that searches columns C and E (on sheet1) for any cell with data.
if finds data in either C or E, it copies that entire row to sheet2 in the next avilable row, and adds a date stamp to column F

thanx in advance

 

[shy07014]

<TABLE id=HB_Mail_Container height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0 UNSELECTABLE="on"><TBODY><TR height="100%" UNSELECTABLE="on" width="100%"><TD id=HB_Focus_Element vAlign=top width="100%" background="" height=250 UNSELECTABLE="off">ok, i tried it again, and it worked no problem, thanx alot for all ur help, Peter_SSs.
</TD></TR><TR UNSELECTABLE="on" hb_tag="1"><TD style="FONT-SIZE: 1pt" height=1 UNSELECTABLE="on">
</TD></TR></TBODY></TABLE>