In principle it's simple but it would help if your provided more detail.

Specifically, where should Excel look for the last number. Is it in the open
or another workbook or a file.

"huwzee" wrote:

i want to set up automatic next number generating for a purchase order spread
sheet