"JLatham" wrote:

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


++++++++++++++++++++++++++++++++++++
Thankyou JLatham

Ive now learnt how to create a Data Validation List..

What i did was create 2 fields..
1st field.. Date Selection Validation List
2nd Feild.. Category Of Expense validation List

My only question at this point is...

How do i create a data entry box, then have it so the data entered will
use the validation selections to put the text into the right cell?

EG
Select Date: ( 03 Jan 07 )
Select Expense: (Entertainment)
Enter Amount : ( $25 ) Then press Enter

I want to type $25, hit enter, it saves, and it appears below on the correct
field, it then clears the box for another entry)

Expenses | Home & Garden | Entertainment | Food |
Date
01 jan 07
02 jan 07
03 Jan 07 $25
04 Jan 07
05 Jan 07


thankyou for your patience with this.