Copy cells from rows from one worksheet to another in same workbook based upon criteria

Hello All,
I'm trying to create a worksheet(Bill of Materials) that searches another worksheet(Internal BOM & Hours) for parts that have quantities entered. Once an item is found with a quantity entered I need specifc cells from that row copied to the Bill of Materials worksheet. I would like to copy internal part number to internal part number, manufacturer to manufacturer, description to description, manufacturer to manufacturer, QTY estimated to QTY, U/M to U/M, external Unit Cost to Unit Cost, and Ext. Cost to Ext. Cost. Essential the internal spreadsheet I will be working and will have thousands of line items but the other spreadsheet should only have what I'm going to use for that project. I would also like to specify at which line the search should stop working because I will have data at the bottom of the Internal BOM & hours worksheet that should not be taken into consideration.

I hope someone can help me with this.

I have attached a sample workbook for anyone to review.

Thanks to anyone that can make this work me because this is outside my skill level.

Originally Posted by jraj1106

Hi

Which data is to be inserted into "Manufacturer Part #" col?

The manufacturer part # will be a combination of the letter and numbers.

This will be the part number I reference when ordering from a vendor

Thanks. I incorporated it into my spreadsheet and it works great. The one piece that I know will come back to bite me is to have an "or" to not copy blanks in the quantity or a 0. I noticed that if I enter a quantity of 0 it copies that row over as well. If you could tell me how to have an or to not copy blanks in the quantity or a 0 that would be great.