Generate next sequence number from data in another sheet

[willow1985]

Hello,

I am creating an excel spreadsheet that has 2 tabs: Log and New Data

On the Log tab there is a list of logs currently numbered 1-832.
On the New Data tab I want to create an area where people can key new log information and then I will add an update button complete with a macro that will copy and paste the information into the log tab in the first available blank cell in column A.
However on the New Data sheet I want the first cell to always display the next number sequence from the Log tab (column A), so the next number would be 833.

What formula could do this for me?

Thank you

Carla

 

[steve the fish]

You could use MAX plus 1.

 

[willow1985]

Perfect. Thank you very much