Using Windows XP, MS-Excel 2003 SP1
I hava a report where the user selects a country from a validation list and it shows results for that country. It also show five or less questions for the country selected which the user has to anwser in specific cell.
Is it possible to create a macro that saves the anwser for each question in another sheet in that same workbook and when the user changes country it brings a new set of questions and clears the answer input cells?
I hava a report where the user selects a country from a validation list and it shows results for that country. It also show five or less questions for the country selected which the user has to anwser in specific cell.
Is it possible to create a macro that saves the anwser for each question in another sheet in that same workbook and when the user changes country it brings a new set of questions and clears the answer input cells?