Forum Discussion
Creating Drop Down Lists for Data Entry
I am new to excel, and am creating a budget workbook. I have sheets for each month, with entries for different expenses. These sheets all contain various formulas to automatically calculate total $ s...
BoCFes Consider collecting all your transactions in one single (structured) table and create any summary you want from it, using one or more pivot tables, on demand and letting Excel do what it does best.
No need to keep separate tables for each month. And as you probably already figured out from your internet searches, you can create lists that contain all the options for your drop-downs (data validation) in the transactions table.
No need for VBA coding either.
Riny_van_Eekelen That's a very good point, and much simpler. Thank you for the advice!