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

Hi Mike

i need it to generate the next number in the sequence i.e. 001, 002, 003,
etc for each individual purchase order, it should look for the number from
the previous purchase order, i just want 1 specific cell on the spreadsheet
to do it.

thanks,
steve

"Mike" wrote:

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