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

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

87daver

Hi Scott, Thanks for the quick reply. Can you elaborate on your answer? What is a relative reference? Thanks!

ScottGem

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,