View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
crusty53
 
Posts: n/a
Default If No is deleted in middle of sequence,Nos alter after deleted No

I have a group of numbers,I delete one number in the middle ,i want the
numbers
after that number to reduce by one so that numbers still run in order.How do
I do this.Thanks in advance .