software

I'm a leader on a camp for kids aged 12-15 and I want to create a sort
of database for the tuck shop.

I want a drop down menu to list all the campers and leaders.

Then I'd want the account for that person to show up. There will be a
total of how much money they start with (we get their $10 or whatever
at the start of the camp), and then as we type in the amount of the
things they buy, that should be subtracted from their total. It needs
to be able to go into minus because a lot of leaders pay later.

By the end of the camp I'd want to be able to easily flick through to
see what people need to be given change, how much people owe, and the
total amount of money the tuckshop has made.

Firstly, thanks a bunch if you read through this!! What I'd like to
know is if they're is a tutorial out there for what I'm trying to do,
or if you've done something similar and how you did it. If you've done
something kinda close then perhaps email me an example so I can try and
work it out myself. ( )

Thanks for your time. ^_^--
aikochan86
------------------------------------------------------------------------
aikochan86's Profile: www.excelforum.com/member.php...oamp;userid=30002
View this thread: www.excelforum.com/showthread...hreadid=496895Why have a list, why not just a simple table.

Names in A2:An.
Start amount in B2:Bn.
Formula in C2 of =B2-SUM(D2:IV2), copied down to Cn.

Then as they buy stuff, the amount is entered in the next available column
for that person, the remainder automatically updating.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;aikochan86quot; gt; wrote
in message ...
gt;
gt; I'm a leader on a camp for kids aged 12-15 and I want to create a sort
gt; of database for the tuck shop.
gt;
gt; I want a drop down menu to list all the campers and leaders.
gt;
gt; Then I'd want the account for that person to show up. There will be a
gt; total of how much money they start with (we get their $10 or whatever
gt; at the start of the camp), and then as we type in the amount of the
gt; things they buy, that should be subtracted from their total. It needs
gt; to be able to go into minus because a lot of leaders pay later.
gt;
gt; By the end of the camp I'd want to be able to easily flick through to
gt; see what people need to be given change, how much people owe, and the
gt; total amount of money the tuckshop has made.
gt;
gt; Firstly, thanks a bunch if you read through this!! What I'd like to
gt; know is if they're is a tutorial out there for what I'm trying to do,
gt; or if you've done something similar and how you did it. If you've done
gt; something kinda close then perhaps email me an example so I can try and
gt; work it out myself. ( )
gt;
gt; Thanks for your time. ^_^
gt;
gt;
gt; --
gt; aikochan86
gt; ------------------------------------------------------------------------
gt; aikochan86's Profile:
www.excelforum.com/member.php...oamp;userid=30002
gt; View this thread: www.excelforum.com/showthread...hreadid=496895
gt;