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: http://www.excelforum.com/member.php...o&userid=30002
View this thread: http://www.excelforum.com/showthread...hreadid=496895

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)


"aikochan86" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=30002
View this thread: http://www.excelforum.com/showthread...hreadid=496895