I have a daily report that I pull from SAP. It's quite a messy excel format and I have no way to filter the data prior to extraction. Here's the list of what I'd need to do:

1. Find the phrase, "Summary By Material", Go up 2 rows, then delete all rows ABOVE that point. (EXAMPLE: "Summary By Material" is in row 1575. I want rows 1573 and all above deleted.)

2. Find the phrase, "Summary By Delisted", Go up 2 rows, then delete all rows BELOW that point. (EXAMPLE: "Summary By Delisted" is in row 5953. I want rows 5951 and all below deleted.)

3. Find and replace, "Material Description Order Qty Cut Qty" so that "Material", "Description", "Order Qty", and "Cut Qty" are in their own column, shifted over one row. (EXAMPLE: "Material Description Order Qty Cut Qty" is in cell A1576. After the find/replace, "Material" is in A1576, "Description" in B1576, "Order Qty" in C1576, and "Cut Qty" in D1576.)

4. Delete all blank rows with no text in column C

5. Delete all rows with text in column A starting with "KZQ" or "YNB"

Thanks to anyone who is able to help.