Spratt_Cary
07-08-2009, 12:50 PM
I am attaching an example of a evaluation results spreadsheet. Yesterday I received help, but after testing, determined that the VB script, although great, will not work for this particular situation. And of course I need help, again.
Let me describe what is happening now. The VB script is separating multi-responses from one cell to individual responses in individual cells (responses separated with a ":") with a double click. Cells are added directly below the double clicked cell (multi-responses cell), Leaving the columns on the left and right unchanged.
The problem, the responses are not associated with a role type. (Question 1 in the example spreadsheet).
What is needed, once I double click on the multi-response cell, rows would be added, duplicating the information across the original row.
Don't know if this can be done? But I have seen amazing things come from this site.
This would allow us to see what users are actually doing and create more role specific training.
Any help will greatly appreciated.
Brenda
Let me describe what is happening now. The VB script is separating multi-responses from one cell to individual responses in individual cells (responses separated with a ":") with a double click. Cells are added directly below the double clicked cell (multi-responses cell), Leaving the columns on the left and right unchanged.
The problem, the responses are not associated with a role type. (Question 1 in the example spreadsheet).
What is needed, once I double click on the multi-response cell, rows would be added, duplicating the information across the original row.
Don't know if this can be done? But I have seen amazing things come from this site.
This would allow us to see what users are actually doing and create more role specific training.
Any help will greatly appreciated.
Brenda