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
to get the budget category entry and date from and another cell to enter the
amount into and a Worksheet_Change() event to detect when the budget amount
entry changes and go put the amount in the proper cell.

Another way, and this seems a little more like what I think you are looking
for, would be to set up a user form that would do much the same actions - 2
list boxes and an text entry box and a couple of command buttons should do it.

Third way would be to set up much like 1st way I described, but on a
separate sheet in the workbook.

If Excel's Help on topics such as Data Validation, the worksheet On Change
event and user forms don't get you the information you need, feel free to get
in touch with me at HelpFrom @ jlathamsite.com (remove spaces).

"Daniel Bunt" wrote:

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..