Data extraction

I have a workbook with sheets "A" and "B". All sheets have identical columns and similar data from different sources.

I have another sheet "C" where I have the same column labels. This sheet has some data in some columns.

The objective is to use the data in sheet "C" as crteria and identify the rows containing this data and copy them to sheet "C".

These sheets have big amounts of data - thus it will help if any guru can suggest (or write ) a macro.

many thanks.

Simon,

Thanks a lot. It does what you said. However, me being a Dumb in coding, need a little more.

I need to match the three populated cells in sheet "C" and that should be the criteria for copying the entire rows into "C" from "A" and "B".

I need to combine three cells in the evaluation and if all true, then copy a row or selected cells to "C".

Should be simple - for you.

Thanks in advance.

Originally Posted by Simon Lloyd

This should do what you need:

Please Login or Register  to view this content.

Thanks a zillion, Simon. It worked with minor adjustments in offset values. Everything else is great.

Thanks again.