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

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

yes latham. thats the idea. so i can start the incrementing again at say cell
h21 for arguments sake. or any cell really

"JLatham" wrote:

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

I presume you got this settled?

If not, to take it further -
in the first cell in a new column, reference the last cell in the previous
column and modify your incrementing formula accordingly. Then the 2nd cell
in the new column will pretty much be like the regular ones in the previous
column. Each time you start a new column you just have to do special setup
in the 1st 2 cells. If the columns are of equal length and adjacent to one
another, once you've done this once, you should be able to drag the formulas
to the right and they should automatically update themselves to get the
correct reference.

"Joe Black" wrote:

yes latham. thats the idea. so i can start the incrementing again at say cell
h21 for arguments sake. or any cell really

"JLatham" wrote:

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