I have a very long list of data that fills A2:A10000 and some of these have corresponding data in column B.

What I want is for excel to automatically scan the cells and if B2 = empty cell I want it to delete cells A2&B2.

I want this to happen all the way through cells B2:B10000 to remove the blanks and corresponding data.


Im not sure if I can do this with a macro or VBA but any help you can give will be greatly appreciated as im new to this.

Thanks