Spreadsheet help please.

scotty

troo,

The drop down list is useful when you want to restrict the value of a cell to one of a limited number of values. For example the list could consist of a number of names. By using a drop down list you avoid the possibility of entering the name incorrectly. While this is not normally a problem, if you then search for cells with that name, you would miss the incorrectly entered example.

scotty

troo,

Just realised that did not answer your question! The drop down list in your example would only be useful to list the items you normally buy. To associate a price with each item you could use a lookup table. So in column A you could use a drop down list to select the items you plan to purchase and in column B you would have a look-up function which finds the associated cost for that item. Obviously, the information linking an item to a cost must be listed somewhere.

Dunkyboy_2

Thankyou for all the suggestions, i'm gonna need to spend some time on this.

beaker141

If you want to track your spending, then take a look at Microsoft Money or Quicken. You can take your Tesco receipt and split it down into categories if you like, at a total excess you could list every single item on the receipt. There are then lots of built in reports toanalyse your spend by the categories.

I use Microsoft Money but mainly to keep track of a load of stoozing activity - I forget whats what otherwise. I have lots of pretend accounts which hold a reserve to pay off various debts when required.

beaker141

Pivot tables are excellent for large amounts of data. I use them daily at work and love them.