auto number

[Pammy]

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.

 

[FSt1]

hi
and where would these auto numbers appear?????

As a side note, most intelegent excel users don't use merged cells.
reason....it may look good on the screen but IT SCREWS everthing else up.

supply more info on why the cell need to be merged and..... looking cool
isn't a viable reason.
also supply info to the first question ie where would the auto number
appear???

Regards
FSt1