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, would like that code to be shaded)

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.

Note: I have posted the same on 'Mr Excel' yesterday, No replies.
Thank you
FLDS

HI,

Perhaps a workbook would help. Also can you give the thread address for "MrExcel".
I'm sure this may help in providing a feed back.

Hi Charlesdh,

Here is the link:
http://www.mrexcel.com/forum/excel-q...teria-met.html

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-questions/508240-visual-basic-applications-copy-rows-based-criteria-new-sheet-file-3.html

Thanks

flds,

Can you provide a copy of the workbook? Redacted.
Its far simpler to see than it is to try and create.

Charles

Hi charlesdh,

Sorry, I did not reply earlier. I was out of the country and returned 2 days ago.
Thanks for your reply. I project was completed by a colleague, when I was away. It was done without a macro or formula, the hard way.

Thanks once again.
FLDS

Hi,

Thanks for letting us know.