Copy values to new sheet if criteria is met

Good afternoon all,

Apologies if this is a stupid question i am new to VB. I am trying to write a simple code to copy the row of data (and possibly formatting) from one sheet (Datasheet) to another (Overdue) if the value in row AE = Yes. I wrote the below which has the issue of copying the actual formulas. Additionally i would like to tell the code to start pasting from cell A2 so i can keep my headings.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Pytheus

If your data has headings and starts in cell A1 you could also use autofilter instad of looping through rows.

Please Login or Register  to view this content.

Alf

Works a treat, cheers.

You are welcome.

Thanks for feed back and rep.

Alf