Hi All,
Here i am attaching my sample files.
Actually i have prepared a report for a questionnaires.
Step1->prepared a sample questionnaires in excel and providing options for users to select his/her own option.
Step2->Prepared a template excel file like it will read all the excel files data which are sent back by the users after filling the questionnaires from a folder and showing the report too.
Problems from Step1:
As of now i am providing all the questions along with options in "Sheet2" and after seeing these options the user can able to select the option code provided in "Sheet1" in each question wise.
Is there any alternate procedure to avoid this kind of problem.
Problem from step2:
->Here in the "home" sheet,I am able to list out all the files in a folder using a macro enabled button.(How can i restrict for only .xlsx files).
->In "Sheet1", I am reading all the excel files rows data only present in a folder using a macro enabled button.
1) If i put Line5 to Line9 after Line19,the data is reading from the last empty line. How can we customize this one.
2) When ever reading "User Name" column is having hyperlinks but those are not working.How can i make them work.
3) In Other columns the data along with list controls are coming but how to avoid the list controls.
4) In the report What ever the values selected from the drop down list provided in row2 based on that only the values are showing .
That means always only one value is showing.How can i provide the option to select multiple values and show the report with full values.
5) How can i show the effective good looking chart with my data.
Please help me to solve these issues.
Thanks in advance.
Regards
Rav
Bookmarks