tracking numbers input and dropdowns

bandito9111

New Member
Joined
Apr 24, 2011
Messages
11
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,122,973
Messages
5,599,124
Members
414,291
Latest member
yanqing06

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top