How do I auto complete cells?

Hi,

I use excel to keep on top of my monthly budgeting.

I've basically got the following columns:

Date, Details, Amount Paid, Amount Received. The rest of the colums are the categories such as shopping, spendo, gas, electricity, etc...

My question is: How to I configure the spreadsheet so that the category columns autofil when I input the relevent information in the details and amount paid/received columns.

i.e. If I put 'water' in the details column and 50.00 in the amount paid column how do I get the relevant cell to autocomplete in the water column?

I hope this makes sense? Sometimes I'm guilty of using a hundred words when only ten would have done!

Cheers,

Gary

can you upload an example?

Here you go.

How about this:

budgeting_example(1).xls

Changes:

- What was at the end I added you on the top. Reason, you can add now data down to the infinity (more or less) and you always gett results on the top (didn't correct them)...

- You choose from drop down menu in the list for Details. However, you'll need to rename duplicated names (for example Car) into different (for example Car leas. Car Ins) and so on...