Dynamic Input for multiple ranges Excel

[anhnguyenngoc2002]

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.

[flying008]

Hi, @anhnguyenngoc2002 

Another way fyi.

Input						Output
F1	F2	F3	F4	F5		Reporting Month	Jan-23	Feb-23	Mar-23	Apr-23	Range
Sales						Company A	1366	2944	2965	2343	Sales
Reporting Month	Jan-23	Feb-23	Mar-23	Apr-23		Company B	1488	1921	2372	2248	Sales
Company A	1366	2944	2965	2343		Company C	2845	2127	2561	2679	Sales
Company B	1488	1921	2372	2248		Company D	1918	2521	2183	1826	Sales
Company C	2845	2127	2561	2679		Company A	0.5966	0.5781	0.5823	0.5668	Completion
Company D	1918	2521	2183	1826		Company B	0.5312	0.4427	0.459	0.5311	Completion
						Company C	0.4786	0.4433	0.4766	0.559	Completion
Completion						Company D	0.5913	0.5511	0.9269	0.8394	Completion
Reporting Month	Jan-23	Feb-23	Mar-23	Apr-23		Company A	99	87	82	97	Rewards
Company A	0.5966	0.5781	0.5823	0.5668		Company B	79	88	83	70	Rewards
Company B	0.5312	0.4427	0.459	0.5311		Company C	97	88	99	78	Rewards
Company C	0.4786	0.4433	0.4766	0.559		Company D	98	89	90	87	Rewards
Company D	0.5913	0.5511	0.9269	0.8394
Rewards
Reporting Month	Jan-23	Feb-23	Mar-23	Apr-23
Company A	99	87	82	97
Company B	79	88	83	70
Company C	97	88	99	78
Company D	98	89	90	87

[nagakavyasri]

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