Copy Multiple Rows to new workbook when multiple criteria is met.

[flds]

Hello,
I have a huge workbook called “Master Tool List” (MTL) that has 10,000 rows of data in each sheet called ‘Training’ and ‘Production’. I need to extract the row data to a new workbook when criteria is met.

I have another worksheet called “Criteria List” (CL) with column ‘B’ having 1000+ rows of unique codes which are grouped by column ‘A’. These codes are in both sheets of the MTL workbook
I need to lookup each of these unique codes from each cell and extract the row data from MTL into a new workbook. Data to be copied to the next available blank row.

(i.e When data for the first code is found, it could be 1 row or 10 rows+, the second code data should be copied to the next blank row. Sometime a code is not found)

At the moment I am extracting the data by filter > copy > paste, group by group and save the workbook. I did this whole day today and found it tedious, repeating the key strokes over and over.

Is it possible for someone to put together a simple Macro. This will be of great help and will be appreciated.

Thank you
FLDS

 

[flds]

Hello,

I am surprised that I could not get a reply to my request.

Note: I have gone through the forums and also the web to find out if I could find a code or something similar to works for my requirement. As I could not find the code as per my requirements I had to request for some Pro to help.

The code here looks similar, but not what my requirement is, see link below.
http://www.mrexcel.com/forum/excel-...opy-rows-based-criteria-new-sheet-file-3.html



Post #1
"(i.e When data for the first code is found, it could be 1 row or 10 rows+, the second code data should be copied to the next blank row. Sometime a unique code is not found, this unique code should be shaded)

Note: I have also posted a request on MSOffice Forum, see link below
Copy Multiple Rows to new workbook when multiple criteria is met.

Waiting for a response.

Thanks