I need a form which the users will use to modify the pivot table, there will be some parameters which the users can select to see the pivot table the way they want to. I am attaching the excel file which has some of the work done, if you look at the form tab, that is a very basic look i am looking for, of course if you can pretty up the form that will be great.
This is a survey data, there are two types of questions: Importance and Satisfaction. The first thing you will see in the form is the ability for users to select the type of question, as soon as they select the type the drop down below changes the questions. Below the questions are the variables which the user can select, whichever check box the user selects, those variables will form the column of the pivot table, example can be seen in results. Below the variables I have a option called Filter where the user can filter the results by a particular variable for example a user can filter Gender by Female. The user has two option to see the data, by Table which will take them to the pivot table and by Graph which will take them to the graph sheet.
This is a simple macro, I could have done but I am very busy on other projects and thus require your help