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.