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