Thread: auto number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default auto number

If I am creating tickets and in column A I have merged A1-A5 and A6 is
skipped and A7 is skipped, then A8-A12 is merged and the next 2 is skipped.
Is there a way to auto # the merged cells? example merged A1-A5 is 518 and
A6 and A7 skip, then A8-A12 is 519, etc.