copy copy row of data to empty row in sheet2

[shy07014]

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

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

thanx in advance

[antoka05]

Try to use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[shy07014]

havnt tried yet, but code looks really good, only i dont see anywhere the code for the date stamp?

thanx shy

[VBA Noob]

shy07014,


Cross Post Please read forum rules below about cross posting

VBA Noob

[shy07014]

sorry, im new i didnt know, just read the rule, thanx for the info.

[antoka05]

I apologize but I forgot timestamp statement. Here is the new macro:

Please Login or Register  to view this content.

Regards,
Antonio