Passing user defined value to get specific result

Hi Team,

I have a whole year data using that there is monthly reports are generating e.g I have Jan-Dec Raw data and my workflow generate monthly reports. So whenever I need 1 or 2 months reports I needed to run all the data and take the result manually. So the requirement is that when I enter Jan then It has to take Jan month data and generate report for the same, if I enter Jan and Feb then it have to run data for Jan and Feb and generate report for two months.

So basically I needed to pass run time value and execute the workflow for that specific value. I believe that it can be achieved by using macro, as I did not worked on macro previously I need a help for this problem.

Macros

Batch Macro

Accepted answers

poojamate92

Hi @atcodedog05 ,

I appreciate your quick response. Attached is the sample data which contain Date and value column. In Date column there are Jan to Dec dates So I need to pass run time input when I enter 'Jan' month then the result shows Jan month data, when I enter Jan and Mar then it shows data for Jan and Mar and so on.

We can use text or list anything for that.

Thank Tou.

Sample Data.xlsx

All comments

atcodedog05

Hi @poojamate92 ,

You can build an app or provide this options in a macro. I need few info how to you want to select month do you want a text box interface or list box (list of options) interface.

If you provide some sample data we can quickly help you out with a workflow 🙂

poojamate92

Hi @atcodedog05 ,

We can use text or list anything for that.

Thank Tou.

Sample Data.xlsx

atcodedog05

Happy to help : ) @poojamate92

Just a gentle suggestion you need to mark the helpful replies for the usecase as the solution.

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703