Data Validation issue help request
 

Hello,

I am in dire need of an Excel expert to help with an issue. I have tried
Contextures.com to no avail and am hopeful someone can help me here. I use
Excel 2003 and am trying to do the following:

- I have a team of 35 cheerleaders, (13 year olds) of which I am the team
business person. Each child has 10 raffle tickets that I must keep track of
as they are sold. The reference numbers could be anything from 1001 - 1010
but I am trying to figure a way to create a drop down list of each childs
raffle book and as selected, account for the sale and remaining tickets.

For ex:
Mary has 10 tickets to be sold for one dollar. On the team worksheet,
(Sheet 1), I create the list and reference name. On sheet 2, I add the drop
down for validation. Now what do I do?

How can I create another field that when I select the ticket sold from the
list - Ticket #1001:

a. It is validated against the number of tickets for Mary, (10)
b. Enters in an cash amount in another field, ($1 accumulating)
c. Subtracts that sold ticket number, (ticket #1001), from the list,
(hidden?) and shows ONLY the remaining tickets that Mary has to sell,
(tickets #1002 - 1010).

I would prefer to do this rather than create a named list for 35 kids, and
add 10 raffle tickets per child editing sales manually. Anyone have an idea
how to do this?

Your help is appreciated,

Thank you