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

You can reference the number on the previous sheet using a relative reference then add 1 to it.

Quote:

---

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!

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,