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
Bookmarks