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
Solved! Go to Solution.
Hi @pokhan27
Macro would be something like this
And workflow would be something like
Hope this helps : )
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
Hi @pokhan27
It would be something like this.
App1: Load sheet names
App2: Let user select sheetname
use this guide for downgrading the packaged workflow if needed.
Hope this helps : )
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
Hi @pokhan27
You are in the right direction. Here is a simple app workflow how you can do it.
QTD:
YTD:
Combine the above scenarios of sheet selection and containers. I kind of feel your usecase seems to be quite more complex 😶
Hope this helps : )
i did came with this solution but am looking to have only one input file where user can select the sheet name
