Dear All,
I have responses from a survey entered as numeric values on sheet 1 (see attached file). I need a vba code that will transfer/copy the contents of sheet 1 to sheet2 and in addition, convert the numeric values of the responses into words - using the following conversion codes:
1 = Strongly Agree
2 = Agree
3 = Neutral
4 = Disagree
There is also a summary column after Q21. The numeric responses for the summary column should be converted as follows:
6 = Excellent
7 = Best
8 = Very Good
9 = Good
I wish to add that the respondents for any survey undertaken will never exceed 30 i.e. the respondents will never cover more than 30 rows counting from row 2 in sheet 1. There may be times when they might be less than 30 respondents for e.g. 10, 15 or 20. But they will never exceed 30, and therefore I will never use more than 30 rows from row 2 in sheet 1.
With the numeric responses converted into words and placed in sheet 2, I wish to then use Sheet 2 for my result analysis.
I have a baby knowledge of vba - although I am learning. I would like to automate the conversion of the responses, and should be very grateful for any help with this, please.
Thanks all for your help.
Newqueen
Bookmarks