Dynamic form feeding a database....

[Gids007]

Hi There,

We are trying to use excel in several ways. We have a survey that our staff fill out, a series of questions some are answered yes or no, some are answered on a scale from 1 to 5. The questions are different for each role.

We currently have a workbook with a sheet for each role. The staff member selects the appropriate sheet, answers the questions, saves it with their name as a reference.

So, some poor person has to collate 200 separate spread sheets so we can see a aggregated view of the answers.

I want 1 sheet that will display the right questions depending on the role selected. Once the user has answered the questions I want that data, plus data about the user (name, role, branch etc), to then be appended to the existing data. I am happy if this stays in excel as we use tableau to aggregate it.

Any help, much appreciated.

 

[My Aswer Is This]

I have this newest script doing this:
When you enter a new value like Math the question previously entered is cleared and a new question is entered below.

When you double click on B1 the question and answers are copied to Sheet named Master.

Now I can make changes if you prefer it to work another way.
Like we could instantly clear the question and answers just after copying the question and answers to sheet named master.