Select specific worksheet using Macro

[pokhan27]

Hi Expert, 

i have one input file but i want to have a macro that will give a user  to select the worksheet

for example: 

i have two sheets in a workbook and i want to create a macro that allows me to select the worksheet

[atcodedog05 · Accepted solution]

Hi @pokhan27 

You want them to select the sheet in file browse and also again in dropdown select which sheet ?

[pokhan27 · Accepted solution]

i want them to select the sheet in file browse only

[atcodedog05 · Accepted solution]

Hi @pokhan27 

Now its more clear and i was able to do this. I am toggling container based on selected sheet using condition tool.

QTD:

YTD:

Hope this helps : )

[atcodedog05]

This was a fun challenge 🙂

Happy to help : ) @pokhan27 

Cheers and have a nice day!

[pokhan27]

I have all the excel file with more than 80000 rows, and when i try to run the app it is giving an error. File browse option have an issue with large data set. 

is there any way to prevent this? 

[atcodedog05]

Hi @pokhan27 

I dont have idea on this. You can post it has a new question. Others take a look into it and help you out 🙂

[pokhan27]

sorry posted in wrong dicussion , i have posted in other discussion