Thread: Add row after various groups of numbers.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh O. Josh O. is offline
external usenet poster
  
Posts: 77
Default Add row after various groups of numbers.
I have a sheet that contains rows with customer numbers:
847300001
847300001
847300020
847300015
847300015
847300015
847300002...

What I need to do is a blank row after each groups of numbers:
847300001
847300001

847300020

847300015
847300015
847300015

847300002...

The numbers will change each time I run the report. Any way I can do this?

Reply With QuoteReply With Quote