Forum Discussion
Automatically update for next available number
I am currently working on a spreadsheet that has multiple pages in the workbook. On the home page I have been asked to add a cell that automatically updates with the next available number in the sequ...
Let's say the numbers are entered in column A on a sheet named Data Sheet.
Enter the following formula in a cell on the 'home' sheet:
=MAX('Data Sheet'!A:A)+1
Since you said:"multiple pages in the workbook"
and
"gets used in the workbook"
You may want to consider a 3D reference:
=MAX(Sheet1:Sheet3!A:A)+1
This requires the Sheets 1 and 3 and any sheets between them are used in the same way. It will get the maximum value anywhere in column A on sheet1 or sheet3 or any sheet between sheet1 and sheet3.
For more detail, read this.
If your sheets to be checked aren't next to each other, then you can consider HSTACK. For example:=MAX(HSTACK(Sheet1!A:A,Sheet3!A:A,Sheet5!A:A)+1
