Autofill Series

[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

 

[Frank Kabel]

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

 

[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.

 

[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

 

[Frank Kabel]

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

 

[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

 

[Rob Sykes]

Thank you, although for some reason it starts at PS 000101-
000150

 

[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")

 

[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.

 

[Peo Sjoblom]

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