We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Setting budget with options
Options

aroominyork
Posts: 3,295 Forumite


This might be a bit off-topic for MSE but maybe some kind person can help. I am preparing the 2024 budget for the charity I head and I want to show my finance committee various budget options. The way I would like to present it is that each budget line would show either a fixed figure (say the cost of annual audit) or a range of options, both for income and expenditure; these would reflect different staffing structures and programme delivery options. Ideally I would like a spreadsheet where I can populate as many columns/options as I like for each budget line, and when you go down the list of budget lines and click an option in each one, it highlights that option and provides a total at the bottom. Does anyone know whether (assuming that makes sense...) such software exists, preferably within Excel? Many thanks.
0
Comments
-
In excel, you could do it as a defined dropdown list for each cell, but it'd be a real faff to do it if you are new to the software. I'm not sure the time involved is worth it for the output.2021 GC £1365.71/ £24001
-
Its not abundantly clear to be honest.
The "click on" selection method would be a bit of a pain to do but should be possible with VBA.
A simpler solution would be to have a spare column near the start where you type the option number you are going for.
How difficult it is to do depends on how robust you want the solutions to be... for example if one row had 4 options but you either clicked a blank cell of the end or typed option 5 that would bring in a zero figure, putting sophisticated validation to stop you going beyond the options would be more difficult.1
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.8K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.7K Work, Benefits & Business
- 598.5K Mortgages, Homes & Bills
- 176.8K Life & Family
- 257K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards