Autofill Series

R

Rob Sykes

Hello i'm working on a sheet where we've assigned receipt
books to canvassers. What I want to do is put the receipt
numbers for the first book then have it complete the
series. The first value in the series is PS 000001-000050,
any help you guys/girls could add would be great.

Thanks in advance
 
F

Frank Kabel

Hi
not really sure what you're trying to achieve. How dow you
want to fill the series?
 
G

Guest

The Value in the first Cell will be PS 000001-000050,
Second would be PS 000051-000100 etc all the way down the
column.
 
F

Frank Kabel

Hi
try the following formula in A1:
="PS " & TEXT(ROW(),"000000")& "-" & TEXT(ROW()
*50,"000000")

and copy this formula down for all rows
 
F

Frank Kabel

Hi
sorry make this
="PS " & TEXT((ROW()-1)*50 + 1,"000000")& "-" & TEXT(ROW()
*50,"000000")
 
B

Bernie Deitrick

Make the formula

="PS " & TEXT((ROW()-1)*50+1,"000000")& "-" & TEXT(ROW()*50,"000000")

and it will work a bit better ;-)

HTH,
Bernie
MS Excel MVP
 
F

Frank Kabel

Hi
then you probably have inserted the formula starting in
row3. Try the following change
="PS " & TEXT((ROW(1:1)-1)*50 + 1,"000000")& "-" & TEXT(ROW
(1:1)*50,"000000")
 
R

Rob Sykes

No...but it in J2 the second row in the column under the
heading. the second one you gave me just returned
a '#name?' value.
 
P

Peo Sjoblom

Then you probably did miss a quotation mark when you copied it unless you
use a non English version?
 
Top