This is what I want to do...

[aikochan86]

I'm a leader on a camp for kids aged 12-15 and I want to create a sor
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
total of how much money they start with (we get their $10 or whateve
at the start of the camp), and then as we type in the amount of th
things they buy, that should be subtracted from their total. It need
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 t
see what people need to be given change, how much people owe, and th
total amount of money the tuckshop has made.

Firstly, thanks a bunch if you read through this!! What I'd like t
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 don
something kinda close then perhaps email me an example so I can try an
work it out myself. ( (e-mail address removed) )

Thanks for your time. ^_

 

[Bob Phillips]

Why 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)