This one is a big ask and I’m almost certain that it isn’t possible but I need it to be. 

I’ve created a quiz in MS Forms and I can obviously open the results up in an MS Excel spreadsheet when I’ve had responses. The problem is, I want to somehow link the answers from the quiz to an existing MS Excel spreadsheet. There must surely be a way even if it means linking each answer from each question to each specific cell.

This is the spreadsheet I want to be able to link it to…

Along the top are the 12 questions. I’d love it if the points acquired (either 1 or 0) would populate the corresponding boxes. This seems like it should be doable.

If there is any other software that could link up with excel in this way, I’m open for suggestions. 

Thanks in advance.

​This one is a big ask and I’m almost certain that it isn’t possible but I need it to be.  I’ve created a quiz in MS Forms and I can obviously open the results up in an MS Excel spreadsheet when I’ve had responses. The problem is, I want to somehow link the answers from the quiz to an existing MS Excel spreadsheet. There must surely be a way even if it means linking each answer from each question to each specific cell. This is the spreadsheet I want to be able to link it to…  Along the top are the 12 questions. I’d love it if the points acquired (either 1 or 0) would populate the corresponding boxes. This seems like it should be doable. If there is any other software that could link up with excel in this way, I’m open for suggestions.  Thanks in advance.   Read More

​