Autofill to a number using a numerial value in a cell update + 1

[Dianegriv]

Good day,

I found with internet a forum answer for someone that had a similar question
as mine and here was the answer:

In B3, use the formula

=IF($A$2<>"",IF(ROW()-2<$A$2,B2+1,""),"")

and fill down for as many rows as you need.

My question is almost the same question but with a small difference:

I made a purchasing document and I need to give a new P.O. number for each
job. What is the formula to have my document change autofill number in the
same cell.

Example: Cell G8 P.O. # 2029 has to change automatically each time we save
the worksheet in order for us to complete a new P.O. with the new number 2030
in the same cell G8.

Thank you for sending me the formula.

Regards,

Diane

 

[tina]

are you working with Excel from *within Access, the relational database
software*? if not, suggest you post your question to an Excel newsgroup.