I am trying to create a macro that will run for each populated cell after cell "A8". The number of iterations will vary. The object is for the macro to run if there is something in cell "A9" - find the text that is in cell "B9" in another tab and then DELETE the entire row in that other tab. Then to do the same for A10, A11 et until a blank row in column "A" is met.

The complicating factor is that SOMETIMES the corresponding "B" cell may be blank and we dont want all of the empty rows in the other tab to be deleted. (not sure if that would happen anyway)

Data may look like this.
Particulars "A8" Topping "B8"
Banana Chocolate
Apple Cinnamon
Pear 'blank'
Orange 'blank'
Pineapple Strawberry

so basically the macro would run each time a value is found in "A" and would delete the row in another tab that contained the value in "B" ignoring the 'blank' items.

I hope i havent made this too confusing

thanks in advance
Quinn