tracking numbers input and dropdowns

[bandito9111]

I work for a church food bank that calls groups of people. they need a better way to display and track what random group numbers are called and how many families are served every day. im trying to make this easier because they are manuall entering this into notepad on an overhead projector and its really technically dfficult for them. they have to move windows back and forth to enter then display the information on overhead.

I need a worksheet that displays / tracks the following.

max of 30 groups
15 people per group
ability to save total groups, total people, and groups called for that day.

1. as a persons number is 'called' its number is input into a cell. i.e. 3

2. when the next persons number is input it is added to a list/array/whatever of called numbers. i.e. 3, 9

3. Cell A5 is dropdown list containing total groups for the day() manually input from cell A12***

4. a. so i have cell A10 displaying current number 9(preferrably using dropdown). and a submit button
b. i have cell A11 displaying all people called i.e. 3, 9 , ......
c. A12=total of groups for the day(manual input)
A13=total people for the day*15
d. i have cell a14 displaying number of people served (A15*15 total of groups (2 in this case x 15 per group)
e. dropdown list(c1:c30) for cell A10- or link form another cell for the input(Cell A5)


a bonus would be a way to make numbers disappear/remove/error from dropdown list c1:c30 as groups are called so for example above the numbers 3 and 9 would no longer be avail/ or showerror like(that group has been called please try again).


any help on any of it is greatly appreciated.
things im looking at are arrays, concenation,vba-which dont know at all

thank you dan