I'm using one of Mynda's Personal Finance spreadsheets as the basis for my own sheet.
I have a table of transactions which includes a Payee name which is validated against a table on another sheet which contains the Payee names. Every month, I get a few (sometimes quite a few) name Payees when I am entering data in the transaction table.
Is there a way to have Excel add these names to the data validation list. Currently, I need to manually add them to the validated list, then return to the Transaction sheet & table.
I am a very basic user of Excel (in my 70's), so not up to complex solutions, although I can usually follow examples by trial and error! I can also follow Mynda's great tutorials.
Thanks.
Please attach sample files which do not include confidential/personal information. Mock it up with fake info if this applies. Post a file with 8-12 records and a mocked up solution so we can work with actual information that is representative of your real files.
Hi, and thanks for the offer to have a look.