# Sequential numbering in excel 2007?

Sequential Numbering in Excel Sheets. Sheet 1 - Copy to Sheet 2 But No in Cell "A1" must Change to next No I.e 0001 to 0002.

 BK201 Posts: 336, Reputation: 749 Full Member #2 Aug 1, 2011, 05:40 PM
I'm not sure if this is what you want but
Go to sheet 2, click on cell A1, type this
=sheet1!A1+1
Drag and drop it to the other cells below.
Or are you trying to solve a more complicated format?
 Naaldekokker Posts: 2, Reputation: 10 Junior Member #3 Aug 2, 2011, 04:06 AM
Comment on BK201's post
Quote:
 Originally Posted by BK201 I'm not sure if this is what you want but Go to sheet 2, click on cell A1, type this =sheet1!A1+1 Drag and drop it to the other cells below. Or are you trying to solve a more complicated format?
Trying to solve a more complicated format. Thank you
 ScottGem Posts: 61,022, Reputation: 29452 Computer Expert and Renaissance Man #4 Aug 2, 2011, 04:19 AM

First when posting a follow-up question or info, please use the Answer options at the bottom of the page rather than the Comments.

Sequential numbering is easy in Excel, you simply enter a formula that increments another value by 1. To help further you need to be more detailed about your needs.

## Check out some similar questions!

Sequential numbering in Excel [ 3 Answers ]

Hi, I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range. For example: AAA 1 BBB 1 AAA 2 AAA 3 CCC 1 I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.

Auto Sequential Numbering [ 3 Answers ]

Is there a way within Excel to Auto Generate a new number every time I open a spreadsheet.ie: I made a Purcahse Order template and I would like for Excel to generate a new Purchase Order number whenever I open it up. Can anyone let me know if this is a possibility.

I have a workbook with worksheets for each day of the month. I need to subtract one day to = equal number of days left in the month. Ex(May 1st there are 31 days left in month, May 2nd, worksheet two, there are 30 days left in the month, and so on and so forth.) Is there a way to have these days...

Microsoft Excel Automatic Numbering [ 3 Answers ]

I have an existing excel spreadsheet, & I want to go back in, create another column, & automatically number it, starting at 1 & going on sequentially. According to the help, I started the numbering, 1,2,3 & used the FILL command (down). It then changes all the highlighted cells to 1!! I can...