How to provide the option to select multiple items and show the report?

[ravikumar00008]

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

[arlu1201]

Ravi,

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

I have one piece solved for you - you have this section of your question -

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.

Add this line

Please Login or Register  to view this content.

after this line

Please Login or Register  to view this content.

[ravikumar00008]

Arlu,

Thanks for your reply
Ya it's working.
As per your suggestion i will break down this thread into separate threads.

But can you reply on this one

Problem from step2:
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.

Because this question is related to this post.

Regards
Rav

[ravikumar00008]

Hi All,

In my report I am selecting the particular value from the drop down and if it is find in the selection i am showing the report.

But now i am able to select multiple values from the drop down.But how can i match this all values at once and show the report.

Here i am attaching the sample file.Please go through it.

Thanks in advance for any help

Regards
Rav

[arlu1201]

Ravi, can you please attach the excel file? I am having problems in downloading the zip file.

[ravikumar00008]

Arlu,

I am not able to attach the macro enabled excel files that is why i zipped and attached.

If You already have the previous attachment(You have already solved one problem) of Template file just paste this code in sheet1

Please Login or Register  to view this content.

Regards
Rav

[arlu1201]

How are you able to select multiple values from the dropdown? What have you changed?

I will try extracting your zip file thru another PC.