drop down lists and forms  
Author Message
obg1491





PostPosted: Top

worksheet functions >> drop down lists and forms

Hello Everyone,

I had such a great response the last time I posted a question, I
figured I'd try it again. This one however may be a little bit more
complicated.

I have a tracking sheet set up where people click off yes/no and it
assigns them a point and then gives a total score. Now I find out that
I need to replicate this for about 100 or so different areas. I was
hoping to be able to put in a drop down list that would list the
specific area. Then when they choose the next area the sheet would
erase itself in order to start over. (and then of course after this is
all done, I'm going to have to put ALL the data together on some kind
of summary sheet).

Can anyone help me in this? I don't even know where to start
searching...drop downs? pivot tables? eek!

Thanks in advance,
yv-

Excel227