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
Hi @pokhan27
You want them to select the sheet in file browse and also again in dropdown select which sheet ?
i want them to select the sheet in file browse only
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 : )
Macro would be something like this
And workflow would be something like
hi Thank you as always but you have hard coded the sheet name. is there any way to give user an authority to select the work sheet
like below:
you can see two input file from same source which have two different worksheet. QTD and YTD. I want an app which gives me an option to select the worksheet
hope you get that
Are you looking for a text box.
If you are saying drop down should automatically update with options only way is chained app. Because normal app wont change the interface options unless its run has a workflow once.
hi
this is my workflow. If i select QTD than the it goes to the QTD calculation and if i select YTD than YTD sheet should be selected
i
You are in the right direction. Here is a simple app workflow how you can do it.
Combine the above scenarios of sheet selection and containers. I kind of feel your usecase seems to be quite more complex 😶
i did came with this solution but am looking to have only one input file where user can select the sheet name
Wont the user be selecting the sheet in file browse tool connected to input tool 🤔
Can you share a more larger and clear snapshot. I am not able to take a good look into it.
just having worst case case scenario, don't want user to mix QTD data in YTD calculation 😉
