Formula to automatically duplicate row information to another area in a worksheet

[Geer]

I create an excel worksheet customized order report out of our Businessworks MRP system and copy it into a worksheet in a seperate workbook. Each row contains different order information and creates a list as follows:
OrderNo,CustomerName,PartNumber,Material,MACHINE,QUANTITYOFSHEETS,SysDate,DUEDATE,Prep,Artwork,Expos,Devel,Etch,S/Dry,Plating,QC,NOTES

My supervisor inputs the specific information for the cells that are in uppercase from the line above. Below the copied grouped list of orders are grouped MACHINEs with they're unique number. A number matching a specific MACHINE will be input into each order in the grouped list of orders and input by the supervisor into the cell in the MACHINE column.

MY PROBLEM: I've tried Advanced Filter, but when an order is closed I have to delete the order row from the copied order list grouping AND the order row that was duplicated in the MACHINE grouping. I tried arraying the formula =IF($E6="4",$A6:$Q6) and =IF($E6="4",$A6:$Q6,""), but I get ALL the order list rows and the orders without the corresponding MACHINE number show either FALSE or are "blank" depending on the formula.
MY QUESTION: Is there a formula that will only pull from the order list the specific MACHINE numbered rows? And allow me to DELETE the order rows "closed" only once from the copied order list grouping?

Help, Geer

[vamosj]

If you could please upload a clean worksheet (no personal information) so that we may assist you better.

[Geer]

I'm new to the forum. Please let me know if the file did get attached.

thanks,geer

[vamosj]

It's attached, I'm going to take a look as see if I can help you with your problem. I do all of this so I can get better at excel myself. ;-)

[vamosj]

Okay, taking a look over this and let me see if I got the skinny of it.


You want to be able to delete a row from "Worksheet" and have a formula to also delete the same order row from sheet "BW PROD. SCHEDULE"

[Geer]

Okay, taking a look over this and let me see if I got the skinny of it.


You want to be able to delete a row from "Worksheet" and have a formula to also delete the same order row from sheet "BW PROD. SCHEDULE"

No.I want to be able to highlight a row of information from the grouped list at the top of the "BW PROD. SCHEDULE" that has been added to one of the grouped rows below it, based on a number in column E,and delete it. At the same time the corresponding row below will be deleted in the designated group. I'm trying to create a formula that will allow this to happen without copying ALL rows and without a "FALSE" or "blank" showing up. Just the unique information.

Thanks. I hope you can help.
Geer