using an input box to allow users type in the differnt fields name
 

Hi. I am quite new at VBA programming and would like some help to solv
this query of mine.

I have a raw datasheet and i wished to do a program to get an outpu
into another stylesheet using an input box to allow users type in the
different fields i have in my first column in my raw datasheet. Let sa
A,B,C,D,E. I hope somebody could help me with this.

something like this:

Regions District Count
A er 3
A rt 3
B vr 2
B ht 4
C ty 4
C ty 7
C yu 9
D oi 11
D oi 5
D we 23
E qe 5
E qe 2
E sd 3


Another query i have is, i hope to sum up some counts for differen
specifications. I noe using =sum() function could help. However,
would like to do a simple VBA program so that it will automaticall
update the sum for me in future when i have an update in variou
specifications. How can i do it? I hope somebody could help me wit
this too..

Thanks

--
ryl
-----------------------------------------------------------------------
ryll's Profile: http://www.excelforum.com/member.php...fo&userid=2860
View this thread: http://www.excelforum.com/showthread.php?threadid=48270