Generate multiple sequential numbers|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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