Forum Discussion
Marsha_R
8 years agoChampion Level 3
What we did in a similar case is keep all the data in one spreadsheet but each country has a different sheet. Then you keep the path to the excel file in a variable or a parameter. Once you've read the country name from the user input, then take that string and concatenate it to the end of the excel file name and that gives you the path for the specific sheet for the country.
Related Content
Recent Discussions
- 7 hours agodhundley