Hello all,
I want to write a code in VBA that deletes row 2 if cell a1 is equal to cell a3 and if cell a1 is not equal to cell 3 then it moves over to cell 2. Then if cell 2 is equal to cell 4 it deletes row 3. This process until there are only 2 rows left for each cell variable on the sheet.
Can anyone help me come up with a code for this?
Kind regards,
Dom.
I want to write a code in VBA that deletes row 2 if cell a1 is equal to cell a3 and if cell a1 is not equal to cell 3 then it moves over to cell 2. Then if cell 2 is equal to cell 4 it deletes row 3. This process until there are only 2 rows left for each cell variable on the sheet.
Can anyone help me come up with a code for this?
Kind regards,
Dom.