M
MusicMan
I need a macro that will from A1 test if B1 is blank and if A2<>"X" delete
row A1, else move down and repeat.
I have a col of customer info in Col B which ahs extra blank rows within.
An "X" in Col A denotes a new customer so the last line of a customer info
should be blank hence the test above for A2
I was a wizz at Lotus macros but new to Excel VBA.
row A1, else move down and repeat.
I have a col of customer info in Col B which ahs extra blank rows within.
An "X" in Col A denotes a new customer so the last line of a customer info
should be blank hence the test above for A2
I was a wizz at Lotus macros but new to Excel VBA.