I'm struggling with something that may either be really simple or horrendously complicated...
I want to be able to use fill series, but instead of filling a range, I fill a selection.
For example, in cell a10 of a sheet, I have the value:
1.1.1.1
Using the fill handle, I can drag a selection down the corner of the cell and fill a series that increments so I get:
a10 = 1.1.1.1
a11 = 1.1.1.2
a12 = 1.1.1.3
a
= 1.1.1.(m)
a(n+1) = 1.1.1.(m+1)
What I want to do is to fill, for example, every 20th cell in a column so that:
a10 = 1.1.1.1
a30 = 1.1.1.2
a50 = 1.1.1.3
a
= 1.1.1.(m)
a(n+20) = 1.1.1.(m+1)
Is it possible (in xl2000) to copy a value in a cell and then paste an incremental series over a selection of individual cells?
I want to be able to use fill series, but instead of filling a range, I fill a selection.
For example, in cell a10 of a sheet, I have the value:
1.1.1.1
Using the fill handle, I can drag a selection down the corner of the cell and fill a series that increments so I get:
a10 = 1.1.1.1
a11 = 1.1.1.2
a12 = 1.1.1.3
a

a(n+1) = 1.1.1.(m+1)
What I want to do is to fill, for example, every 20th cell in a column so that:
a10 = 1.1.1.1
a30 = 1.1.1.2
a50 = 1.1.1.3
a

a(n+20) = 1.1.1.(m+1)
Is it possible (in xl2000) to copy a value in a cell and then paste an incremental series over a selection of individual cells?