I left out that after you create the valdidation cells you can use vlookup
to get the prices

Don Pistulka



"Don" wrote in message
...
If would suggest using data validation cells for the items linked to price
tables. Debra Dalgleish's site will get you satarted:


http://www.contextures.com/xlDataVal01.html

Don Pistulka


"CampFriendNeedsHelp"
wrote in message
...
Hi all,

First of all, I love this site and use it alot. I am hoping someone can
help me out.

I have a list of 360 people in a column who attend camp. They were given
a
stipend to use daily for candy, etc. Each item has specific dollar
amounts
and I want to use this spreadsheet on a daily basis to track money left
on a
campers account so we know how much they have left and notify them that
they
need to refill their money account. I hope this makes sense.

Joe $100
Lisa $75
Mary $200
Kristy $150

(in any column: chips, m&m, pop, juice, etc)

(in any column: $$ amount of each item cost)
I am hoping there is a way to create a shortcut so that I can simply
click
the item that the camper bought (juice, candy) and then have it subtract
it
quickly and show it in a column.

Any help is soooo much appreciated, thank you kindly.