I want to create a payment ledger. We have 6 different accounts. Each account has a different voucher numbering sequence(made up of just numbers). I have created a dropdown list to show which account is paying for a given transaction.
I in the next column, I would want to automatically generate the next voucher number for the specific account which has been selected in the left column. So that it always gives me the next available voucher number for the account selected.
This has been a challenge for me and I am trusting you will be able to help me.
I am grateful for you attention.
Standing by
Thanks
Hi Stephen,
I can think of more than one way this could be done but without seeing your data I don't know which way is best. Please attach your workbook containing the data in question.
Regards
Phil
