Macro to copy data rows to a summary worksheet if the row satisfies a condition

I have a project where I need to copy entire lines of data from multiple worksheets into one worksheet if a certain condition is met within that row.

I have included a test file that contains an example of what I aim to achieve.

In the test file I want to copy every line from worksheet Jan12, Feb12, Mar12 to NoCusip12 IF there is no data in column C.

My actual file will have more worksheets and also more columns, but I can't include my actual file due to sensitivity of the data.

Any help would be great!

Thanks

Another option

Please Login or Register  to view this content.

Another option

Please Login or Register  to view this content.

Thanks for the help everyone! I got it figured out.

Hello cfr,

Can you please, if possible, attach the workbook with the solution you adopted?

Thank you

Naja,
There are two codes and you also have attached sheet where you can test it yourself. All you have to do is copy the codes and put them in the module and see how they work.