Copy Rows from selected Sheet to New Sheet based on Cell Value

**joemcmillen** · 03-27-2008, 10:42 AM

i have a workbook that has a lot of sheets but i need to pull information from the one sheet "Veneer Log" i Need it to make new sheets with the same heading as on the "Veneer Log" (Rows 1 & 2) Sheet but it needs to be filtered by the "Product" Column (H) with a new sheet made for all the diffrent products i.e. Dimensional, Drywall, Corners - Thin V., Accents,..... so each product will have a new sheet with i am hoping someone can help me with this. This log changes Daily and it would be nice to have a sheet with only the same product on it to compare new orders so we can batch run. i hope i have given you enough information so someone can help me with this. i have attached a sample log the real log has about 10 worksheet for diffrent departments but i only need info from the Veneer Log Sheet.

Thanks for everyones help i love this forum and have learned a ton from all of you here.

Thanks again,
Joe

**Charles** · 03-27-2008, 03:07 PM

Hi,

If your copying data from "Vener Log" to worksheets with the name of the item, how will you determine if the data is already on the sheet being copied to?

**joemcmillen** · 03-27-2008, 03:15 PM

it could be a macro that makes a new sheet so there is no duplicate data. the main thing is for each department to know how many orders they have and what is on each order. the products are the same for each department but the material and finish and quantity are all diffrent.

i hope this answers your question. i am a little confused buy it.

cheers

**Charles** · 03-27-2008, 03:31 PM

Hi,

The macro will loop thru the Venner sheet and copy product to the named product worksheet. After the macro is complete you add more info the the Vennes and you run the macro again it will start at row 3 and copy the info on row3 to the worksheet for that product. Which is already there from the previous run of the macro.
Need to someway of tell the macro that the product info already exist.
I'm looking at the job nr. to tell the maco not to copy because its already in the worksheet for the product.

**joemcmillen** · 03-27-2008, 04:11 PM

ok i see the question and the problem now. is it possible when the macro is run that it clears the old sheet first so there wouldn't be duplicates?

we wouldn't ever edit the cells on the extra sheets they are to print and give to the department that they are for the only changes to cells would be made in the original "Veneer Log" cells and that is printed once a week to go to the production meeting to see the over all orders we work on first in first out so we would know what is at the top of the list to get shipped.