Excel 2007 : Auto Generate Next Number

**wisedave** · 04-26-2011, 09:18 AM

Hello,

Is it possible within a column to have the next number sequence auto generated? For example, in column A, I have an ID# that starts with WGT001. When I go to the next cell below that, can you have the next cell auto generate WGT002.

See attached for example sequence.

Thanks for all the help!

-Dave

**Marcol** · 04-26-2011, 09:42 AM

Can't you just drag the cell down?
Use the small square bottom right.

**Domski** · 04-26-2011, 09:49 AM

This would do it automatically for you when you select the next free cell:

Please Login or Register  to view this content.

Dom

**wisedave** · 04-26-2011, 09:55 AM

Originally Posted by Domski

This would do it automatically for you when you select the next free cell:

Please Login or Register  to view this content.

Dom

Hey Dom,

Sorry for the rookie question here but.....where do I put that code?

@Marcol - That works....never knew I could do that....

Cheers,

Dave

**Domski** · 04-26-2011, 09:57 AM

Right click on the sheet tab, select View Code and pop it onto the code page that is displayed.

Dom

**plams** · 05-11-2011, 10:00 AM

Think I have the same problem, and follow the instructions but doesn't have result in my workbook. Is there other operations, like save after put the formula into code area? And if you know if this instruction is valid for my specific need:
I need excel to generate increasing number in every one random empty cell. When I type digit "1" for the first entry I want it to calculate next progressive number for every other cell in random order which I choose and type "1"
Thanks in advance
Best regards
Plams

**Domski** · 05-11-2011, 10:36 AM

Hi,

Please don't post questions in the threads of other forum users as per the forum rules.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom