Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2014, 03:57 AM
flds flds is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows XP Copy Multiple Rows to new workbook when multiple criteria is met. Office 2007
Novice
Copy Multiple Rows to new workbook when multiple criteria is met.
 
Join Date: Apr 2011
Posts: 27
flds is on a distinguished road
Default Copy Multiple Rows to new workbook when multiple criteria is met.


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
Reply With Quote
  #2  
Old 09-10-2014, 12:47 PM
charlesdh charlesdh is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows 7 32bit Copy Multiple Rows to new workbook when multiple criteria is met. Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 09-10-2014, 02:42 PM
flds flds is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows XP Copy Multiple Rows to new workbook when multiple criteria is met. Office 2007
Novice
Copy Multiple Rows to new workbook when multiple criteria is met.
 
Join Date: Apr 2011
Posts: 27
flds is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 09-11-2014, 10:28 AM
charlesdh charlesdh is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows 7 32bit Copy Multiple Rows to new workbook when multiple criteria is met. Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

flds,

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

Charles
Reply With Quote
  #5  
Old 09-30-2014, 09:42 AM
flds flds is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows XP Copy Multiple Rows to new workbook when multiple criteria is met. Office 2007
Novice
Copy Multiple Rows to new workbook when multiple criteria is met.
 
Join Date: Apr 2011
Posts: 27
flds is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 09-30-2014, 09:58 AM
charlesdh charlesdh is offline Copy Multiple Rows to new workbook when multiple criteria is met. Windows 7 32bit Copy Multiple Rows to new workbook when multiple criteria is met. Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Thanks for letting us know.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ranking with multiple criteria angie.chang Excel 0 08-14-2012 04:49 PM
excel vlookup with multiple criteria mpokorny Excel 4 05-06-2012 04:06 AM
Copy Multiple Rows to new workbook when multiple criteria is met. Vlookup or Index/Match - Multiple Criteria ruci1225 Excel 1 01-15-2012 07:31 AM
Sum Product Multiple Text and date Criteria ramki Excel 1 01-09-2012 01:16 AM
Copy Multiple Rows to new workbook when multiple criteria is met. Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft