Forum Discussion
Marsha_R
Champion Level 3
9 years agoWhat 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.