Hello,
I am very much a novice at VBAs or macros (or coding in general), but wanted to see if anyone here might be able to help me out. Not sure how easy or difficult what I want really is.
Basically I have a spread sheet with with a bunch of names in column A (see attached), and then several more columns with questions they answered in an online form. The names of each question are the column headers and their responses fill out each row below. What I want is to be able to output each row of data to a text file (or Word doc would be even better if that is possible) and have it look like:
Name: John
Question 1: yes
Question 2: 4
Question 3: 3
Name: Liz
Question 1: no
Question 2: 3
Question 3: 1
etc.
Ideally each persons responses would be a different file (with their name as the file name), but this isn't the most important part. Even if everything was extracted to a single text file in the format I have listed above, that would save me a ton of time. Any help would be appreciated. Thanks!
Bookmarks