RE: Can anyone povide step by step instructions on how to do the follo

There are a couple of approaches to take to easily solve this.

On the same *** 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 *** in the workbook.

If Excel's Help on topics such as Data Validation, the work*** 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 *** i created to do the following:

Ive created an excel spread*** using simple =sum(cell) commands for the
purpose of a personal budget.. And i would like upon opening of this
spread*** 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 spread***, 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 spread***. 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..


.