keeping track of total dollar amount for campers

[CampFriendNeedsHelp]

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.

[Don]

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" <CampFriendNeedsHelp@discussions.microsoft.com> wrote
in message news:B37C9EDA-E5EE-4F14-8453-943B2E32A490@microsoft.com...
> 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.

[Don]

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

Don Pistulka



"Don" <group@Notpistulka.com> wrote in message
news:%23Zq6wvChFHA.2852@TK2MSFTNGP15.phx.gbl...
> 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" <CampFriendNeedsHelp@discussions.microsoft.com>
> wrote in message
> news:B37C9EDA-E5EE-4F14-8453-943B2E32A490@microsoft.com...
>> 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.
>
>

[CampFriendNeedsHelp]

Hi,

I am a bit confused....Is there a way to show what needs to be in each
column for simple calculations? Do you have an example or is there an
example template from that website?

THANK YOU again,





"Don" wrote:

> I left out that after you create the valdidation cells you can use vlookup
> to get the prices
>
> Don Pistulka
>
>
>
> "Don" <group@Notpistulka.com> wrote in message
> news:%23Zq6wvChFHA.2852@TK2MSFTNGP15.phx.gbl...
> > 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" <CampFriendNeedsHelp@discussions.microsoft.com>
> > wrote in message
> > news:B37C9EDA-E5EE-4F14-8453-943B2E32A490@microsoft.com...
> >> 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.
> >
> >
>
>
>

[Don]

This is simple, but it sould help. Click on the validation cells for the
dropdown boxes.
http://pistulka.com/simplevalidation.xls
Don Psitulka

"CampFriendNeedsHelp" <CampFriendNeedsHelp@discussions.microsoft.com> wrote
in message news:9030F787-D555-4B5A-B25D-422EC5581583@microsoft.com...
> Hi,
>
> I am a bit confused....Is there a way to show what needs to be in each
> column for simple calculations? Do you have an example or is there an
> example template from that website?
>
> THANK YOU again,
>
>
>
>
>
> "Don" wrote:
>
>> I left out that after you create the valdidation cells you can use
>> vlookup
>> to get the prices
>>
>> Don Pistulka
>>
>>
>>
>> "Don" <group@Notpistulka.com> wrote in message
>> news:%23Zq6wvChFHA.2852@TK2MSFTNGP15.phx.gbl...
>> > 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" <CampFriendNeedsHelp@discussions.microsoft.com>
>> > wrote in message
>> > news:B37C9EDA-E5EE-4F14-8453-943B2E32A490@microsoft.com...
>> >> 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.
>> >
>> >
>>
>>
>>