tracking groups called and data

[bandito9111]

Hello, my name is Dan
I work for a church that calls groups of persons for a food bank
I want a simple one cell input i.e. type in group # or use drop-down
then that number that is input is added to next blank cell either row or column
i.e.
I type "4" into cell a1 (or select from drop-down list)
enters "4" into cell a2
next type "12" into cell a1 (or select from drop-down list)
puts "12" into cell a3
next i type "9" into cell a1 (or select from drop-down list)
puts "9" into cell a4, etc,etc
next i type "6" into cell a1 (or select from drop-down list)
puts "6" into cell a5, etc,etc
d4 displays current group number (non blank number )
e4 displays families served-see below
f4 displays groups called-see below
simply put i am looking for a worksheet that
1. tracks groups called(adds to list of cells or array),
2. current group number(displayed in another cell),
3. number of families served(number of non-blank cells in range x 15) (max 30 groups) )
so from example above
input into a1-- 6 enter/tab?(preferred) or (use drop-down and vba?)
:data range a2-a32-initially all blank
a2=4
a3=12
a4=9
a5=6

d3="Current Group"
d4 displays last group called(updating?)
d4=6

e3="families served"
e4=15 x (total groups(non zero cells?))=from example "60 families served"

f3="Groups Called "
f4= 4, 12, 9, 6...(can be concenated list)or
seperate cells
f4=4,g4=12,h4=9,i4=6 .....

thank you very much for any help or any suggestions on what type of formuas, data, arrays, etc to use
Dan W

 

[bandito9111]

using excel 2003 and/or 2007
winxp

I am finding some info but cant seem to put it all together.

thank you very much for any help or pointers
Danw