Assuming series goes from A1 all the way down to A65536...
Set B1 = A65536
and then in B2 set up your formula to continue incrementing the series and
drag on down the sheet?

Or am I not understanding the question?

"Joe Black" wrote:

is it possible to continue an ascending series from one section of a
worksheet to another part. ie. the columns aren't together. numbers like
VMC143 (the sameway you would when you drag a cell down the column.)

thank you