Exporting rows onto a form

I have 300+ forms I fill out each month.
The form contains some contact information at the top, followed by 10 yes/no questions, and ends with a comment section.

It takes forever to individually copy and paste info into each one, and then save them.

I found a VBA that will take each line of info and save it into an individual file, but I'm looking for it to export the information onto this pre-made form AND then save it.

Does anyone have any ideas? Or an help in any way? I am a complete novice when it comes to macro/vba writing, but that's why we have forums like this! :)

This is the VBA for the file export portion - https://www.howtoexcel.org/vba/how-t...#comment-13673. I've also attached a copy of the form that I'm crossing my fingers info can be exported to.

I attempted to attach the VBA code in this same window, but I was encountering an error.

I assume you also have a file with the source data? I can't imagine that your file is exactly the same as the sample file available for download on the page you referenced. Also, I'd name your option buttons in a more intuitive way in the form, respect_yes and respect_no for example.
Also, would the code be contained in the Form file? or the one with the source data (more logical).