87daver Posts: 2, Reputation: 1 New Member #1 Sep 30, 2008, 02:11 PM
New sheet needs new sequential number
When I send a new submittal sheet, I would like to auto assign a new number to a submittal sheet each time I open it. As I have it today, the form is located on the worksheet as an additional tab.

Any help is appreciated!

Thanks
 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #2 Sep 30, 2008, 03:26 PM

You can reference the number on the previous sheet using a relative reference then add 1 to it.
 87daver Posts: 2, Reputation: 1 New Member #3 Sep 30, 2008, 03:33 PM
Originally Posted by ScottGem
You can reference the number on the previous sheet useing a relative reference then add 1 to it.
Hi Scott, Thanks for the quick reply. Can you elaborate on your answer? What is a relative reference? Thanks!
 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #4 Sep 30, 2008, 06:20 PM
A relative referenace is the standard way you refer to a value in another cell, Just type = and select the cell you want in the previous sheet then type +1, You can then copy that formula to each new sheet,

 Question Tools Search this Question Search this Question: Advanced Search

## 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 Generating Sequential Numbers in Excel 2003 [ 2 Answers ]

Hello All I would like to have sequential Auto Generated Numbers in column A of my Excel 2003 Spreadsheets e.g A1=1, A2=2, A3=3 etc. But I would like Excel to auto generate this number, rather than input?

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 .

If I register for a business number in Canada and provide my social Insurance number.. ... will my SIN always be "connected" with my business? In other words, as far as Canada REvenue is concerned are they 2 different entities? I want to apply for Bus # for a sole propriatorship