Formula to Fill a Column with sequential serial #s

[sforluck]

Hello,

And want to thank you ahead of time for any help.

What im looking to do is a formula to fill a column on my log sheet with serial numbers that are sequential.

the thing is they are in batches and can vary in amount 10 to 25, so lets say I have a batch of 20 stickers with a starting number of F321450 going up by 1 each sticker.

I would like to have the serials filled with a data/value cells off the print page where I can enter the starting sequence, next cell over same row would enter how many stickers. Then have that info populate on the log in the appropriate column. I will use different page for each batch.

lets say,
starting number to enter is cell K7 and How many is K8
and the column to fill is at D6 thru D31


Thank you

[FDibbins]

Hi, welcome to the forum

Assuming the format of your stickers is as shown (1 letter and a bunch of numbers - doesnt matter how many), then try this...
D6=K7
D7=IF(ROWS($1:1)<=$L$7,LEFT(D6,1)&RIGHT(D6,LEN(D6)-1)+ROWS(1:1),"")
copied down

If your sticker serials will always only contain 1 letter and 6 numbers...
D7=IF(ROWS($1:1)<=$L$7,LEFT(D6,1)&RIGHT(D6,6)+ROWS(1:1),"")

[sforluck]

Ford,

Thank you so much, its actually 2 characters then 6 numbers. so I used the first example with a correction to allow for 2 characters and works perfect

[FDibbins]

Great stuff, happy to help

2nd formula with 2 letters + 6 numbers...
D7=IF(ROWS($1:1)<=$L$7,LEFT(D6,2)&RIGHT(D6,6)+ROWS(1:1),"")