Personal Budget Worksheets, easy or not?
I would like the excel spread sheet i created to do the following:
Ive created an excel spreadsheet using simple =sum(cell) commands for the
purpose of a personal budget.. And i would like upon opening of this
spreadsheet for firstly it to ask the following, so when i type my amount
into an amounts box it will use the correct cell position.
All 3 questions that follow would be on the one page, with an option to add
another expense entry onto the spreadsheet, or finish & save, then goto view
the budget.
1) Be able within a drop menu select the heading (EG entertainment or
House & Garden etc) so it selects the correct "column" for the amount which
will be entered in Q:3.
2) Then, Select a date from a drop menu so that it selects the correct
"row" so that when i enter the amount spent on this day for the particular
expense it selects the correct cell. that Q:3 refers to.
3) Then, have an entry box which would have been referenced by the
previous selections so that the amount i type into it will be correctly
placed onto the spreadsheet. according to colun and row.
After entered.. when pressing on add another expense it saves the amount
onto the field... then blanks the previous options selected so a new criteria
can be entered in and saved... etc etc.
This surely is possible.. ive spent money to try and learn this but im just
getting no-where.. Please help me if you can..
-Sounds less like a specific question and more like a project which is what
many of us do for a fee.
-There are a couple of approaches to take to easily solve this.
On the same sheet you could simply have 2 cells with Data Validation set up
t