Deleting Entire Rows Based Off of Multiple Criteria

[ccb12]

I have a spreadsheet with column headers: Order Number, Step, Start Date, End Date. It is populated with over 10,000 rows of data. Each row is a different step which means multiple rows can contain information on the same order.

For example, if my data concerned making ice cream cones, an order for a plain vanilla ice cream cone would contain multiple steps: one for taking the order, one for walking to the freezer, one for scooping the vanilla ice cream, one for putting it in a cone, and one for handing it to the customer. That is 5 rows that share the same order number.

If I prepared a chocolate dipped vanilla cone, the steps would be identical to ordering a plain vanilla ice cream cone except there would be an extra step for dipping the cone in chocolate. The order number for the chocolate dipped cone would also be different.

If I wanted to delete all rows for every chocolate dipped cone in this document, how could I do that?

I can't just use a filter to find all rows containing "dip cone in chocolate" because that would leave the other steps associated with those orders in the document. If I just deleted the rows that contain the chocolate dipping step, it would then distort my data to look like I had many more plain vanilla cone orders. Basically I need a macro that can gather all order numbers that contain a chocolate dipping step and then delete all the rows associated with that order.

I apologize for the corny ice cream example but it's the easiest way to describe the problem with my data.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a post