Dynamic Input for multiple ranges Excel

Question

Hi everyone,

I need to input multiple ranges in a same excel file, each range used for a different purposes.

I use input tool to import every range I want to process, however if I have many ranges I have to use a lot of input tools. Instead, I want to use dynamic input tool & text input (where I will enter ranges). After that I can use each range for each calculation. How can I do this? Thank you so much!

I have attached my sample data and a sample workflow for my idea. If you have any better ideas please help me.

Dynamic input.yxmd

Sample dynamic input.xlsx

nagakavyasri · Answer

Correct the format of Range in text Input tool and can use Interface tools to select the range:

Dynamic input1.yxwz

flying008 · Answer

Hi, @anhnguyenngoc2002

Another way fyi.

Input     Output     F1F2F3F4F5 Reporting MonthJan-23Feb-23Mar-23Apr-23RangeSales     Company A1366294429652343SalesReporting MonthJan-23Feb-23Mar-23Apr-23 Company B1488192123722248SalesCompany A1366294429652343 Company C2845212725612679SalesCompany B1488192123722248 Company D1918252121831826SalesCompany C2845212725612679 Company A0.59660.57810.58230.5668CompletionCompany D1918252121831826 Company B0.53120.44270.4590.5311Completion      Company C0.47860.44330.47660.559CompletionCompletion     Company D0.59130.55110.92690.8394CompletionReporting MonthJan-23Feb-23Mar-23Apr-23 Company A99878297RewardsCompany A0.59660.57810.58230.5668 Company B79888370RewardsCompany B0.53120.44270.4590.5311 Company C97889978RewardsCompany C0.47860.44330.47660.559 Company D98899087RewardsCompany D0.59130.55110.92690.8394                   Rewards           Reporting MonthJan-23Feb-23Mar-23Apr-23       Company A99878297       Company B79888370       Company C97889978       Company D98899087