looking for some Excel help - drop downs and multiple cell population

Associate
Joined
24 Jul 2007
Posts
1,894
Location
Swansea, Wales
so I'm after some info on the best way to set up a spreadsheet.

The idea behind it is that you will have a drop down with a limited selection of options (between 3 - 5) upon selecting one or more of the options, it would self populate a list of questions.


in theory it would be something such "lost item" to be selected from the drop down, then a series of questions (when was it purchased, original price etc) would be generated either within excel or mail merged in to word.

Firstly is this something that can be done? if so, whats the best way to go about it

Thanks in advance
 
makes sense. The idea behind it is for newer starters within work, they select what they are dealing with and then it will populate with questions they will need to ask.
It would be subject to change so ideally it will be a quick amendment if required to add in an extra question or remove one :)
 
@Greboth just so I can check as well, with the drop down options, would it be a case if they select Option A, it would populate all the questions, 1 to 6 for example, that is under that table that was selected from the drop down?
 
its a mixture of things lol. in work reviewing at the moment and I been asked to do it as a sideline thing. I will jump in to the drop link when I finish to get it downloaded and have a run through it :)

If I get a bonus for it I will send you a percentage ha!

I will let you know how I get on with it
 
Back
Top Bottom