copy cell x if value of the previous cell = Y

[tonnerre2000]

tonnerre2000.xls

Hi, I want to copy all the data on sheet 2 cell d5 and up if the value on C5 is WCN.

and add it to the list on sheet 1. on a macro

Thank you

[DGagnon]

here is a quick recorded and slightly modified macro to accomplish that

Please Login or Register  to view this content.