Ask Experts Questions for FREE Help !
Ask
    87daver's Avatar
    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's Avatar
    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's Avatar
    87daver Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Sep 30, 2008, 03:33 PM
    Quote Originally Posted by ScottGem View Post
    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's Avatar
    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,
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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 [ 1 Answers ]

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. [ 1 Answers ]

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

Link masterlist from Sheet to Sheet [ 1 Answers ]

Is there a way to create a master list of names in one sheet so that when you add or delete rows or columns in the masterlist the other sheets that use this masterlist will automatically add or delete the changes? How would I copy this list. I tried to link it as a formula but that didn't...

View more questions Search