Thread: simple macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
musicman musicman is offline
external usenet poster
 
Posts: 11
Default simple macro?

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.