I'll be creating a base test scenario. For Eg.
Base Input :
"Verify if the text inside the Search button is $Search"
String Values :
So in the Next sheet, i'll be providing the value of $Search for each locale such as,
Locale $Search au abc br jer in jyr
Outupt:
So on the third sheet, I have to get the output as,
Locale: au Verify if the text inside the Search button is abc
On the fourth sheet,
Locale: br Verify if the text inside the Search button is jer
On the fifth sheet,
Locale: in Verify if the text inside the Search button is jyr
Last edited by comm; 2013-07-17 at 09:34 AM.
I'm not sure I'm 100% clear on what you're trying to do here. At first I was thinking scenario manager, but it almost sounds like you're looking for something like this: http://www.contextures.com/xlDataVal02.html
If you could provide a bit more clarity, and maybe even upload a sample workbook, that would be awesome.
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks