I have a Checkbook Register worksheet that has a column for Type of
Transaction, i.e. ATM, Deposit, CC, etc... I also put my check number
in this same column. To make things easier I use the "Pick from List"
feature to select the type of transaction, saving me the trouble of
typing it every time.

My problem is that a long list of check numbers mount up in this list.
Numbers that I will not use again. I would like to be able to customize
the list to not show all of the previously used numbers and at the same
time give me an option to select the _next_available_unused_number_.

I tinkered with Data Validation and was able to make a custom list that
has all of the transaction types except for the one I really want which
a selection for the next available check number.

If there is anyone that can offer a solution, I would appreciate the
help.


--
icetrey
------------------------------------------------------------------------
icetrey's Profile: http://www.excelforum.com/member.php...o&userid=20329
View this thread: http://www.excelforum.com/showthread...hreadid=423850