Deleting few columns based on a criteria

Dear All,

Good Evening!!!

My below requirement might confuse you, so request you to please go through the attached excel Where I have done changes for the first brand name in the before sheet & after sheet

Its just about deleting content/rows when my requirement meets criteria.

I prepared a format in such a way that one brand has several models for calculating their order, opening stock, Quantity received etc

I want to delete entire row for every brand where Remarks has Quantity received as per order & Ordered Quantity, Opening Stock, Quantity Received & Quantity to be received = zero

I want rows to remain after deleting = max number of rows it occupied under the item shown below

ex: for KEDBROOKE Brand, I've max number of items are 2, So I want to delete next entire rows with remaining 2 rows without deleting

I just also want to delete content (not rows) in the rows that are remain after deleting where where Remarks has Quantity received as per order & Ordered Quantity, Opening Stock, Quantity Received & Quantity to be received = zero

ex: for KEDBROOKE Brand, I've max number of items are 2, So if I have Remarks has Quantity received as per order & Ordered Quantity, Opening Stock, Quantity Received & Quantity to be received = zero with in these 2 rows

DOWNROD/SHACKLE:
CANOPY
ROTOR:
SHAFT:
CAPACITOR:/MAKE
STATOR:
Lamination
BLADE:
MOTOR BOX:
THERMOCOLE TRAY:
STAY CAP / CENTRE PAD:
BEARING
SHOW CAP/ RING
MASTER CARTON:

I hope I didnt confuse you & Request you to please help.

Hope this helps!

the Macro "Delete_Erase_Rows" should perform the desired action on the "before" worksheet.

The macro code is as follows:

Please Login or Register  to view this content.