Creating a questionnaire.....

[Guest]

Hi. I am creating a questionnaire in Excel. In the first question the user
must choose for which department they are filling out the questionnaire by
marking an "x" in the cell next to the correct department. Then for the
other questions, I would like to add that department name to the question if
possible. For example:

Question 1: Please mark an x next to your department.
Drilling
Subsea X
Operations

Question 2: Please comment on "x" procedures as they pertain to you?

I would like to have question 2 all in one cell if possible.

Hope someone can help.

Cathy

 

[somethinglikeant]

Cathy,

By far the best way of doing this I feel would be for the first
question to supply a drop down box (Data- Validation)with the options
for departments.

Say in cell A2 (select this cell)
To do this go to Data > Validation
In allow select "List" In the source section type in your list of
departments seperated by commas eg
Drilling, Subsea, Operations
etc

Then link question 2 to the selection from that box as you request with
a concatenation

In the cell that contains Q2 you should enter

="Question 2: Please comment on "&A2&" procedures as they pertain to
you?"

This will automatically update with different selections in A2


Play around with this...
I have found it very powerful for forms and templates,
as you can mak such things foolproof to the user,
plus there are countless extra settings

I found the website contextures.com very useful.

If you need anymore help feel free to ask

somethinglikeant

 

[Tom Ogilvy]

="Please comment on " &
if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown"))) & "'s procedures
as they pertain to you?"

or in a cell offscreen (perhaps W1, put in the formula)
=if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown")))

then in your questions
="Please comment on "&W1&"'s procedures as they pertain to you?"