Let Excel choose next following document number

[AA Arens]

I want to make a document which has the following purpose: claiming the
next number of a purchase order, quotation or another document.

From a lookup table and a combo box/drop down the person chooses wether

its a PO or Q.
Then in the neighboring cell appears the next number of that document.
So, numbers already claimed before cannot be choosed.

How to perform that? (But, with the possibility to clear the field and
to have the claim be undone)

So it's like this:

choose document PO / Q | next claimed # appears | Person who
claims (manual choose)

Optionally, but I hope it's not thast complex, make three buttons and
each button represents the kind of document. Then on the focussed
field, the next number appears after the button push. So three buttons:


[Cliam next PO number] [Claim next Q number] [Clear field and make
claim undone]


Bart
Excel 2003