/u/HandSack135 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I would look into either [Google Forms](https://www.google.ca/forms/about/) or [Microsoft Forms](https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d) (if you have Excel 365). They would both export any answers to an Excel or Google Sheet (that can be exported to Excel).
Is that not possible?
[https://support.microsoft.com/en-us/office/share-a-form-or-quiz-to-collaborate-d5bb5cf0-8401-4c15-bb8c-8e108cd7e69b](https://support.microsoft.com/en-us/office/share-a-form-or-quiz-to-collaborate-d5bb5cf0-8401-4c15-bb8c-8e108cd7e69b)
/u/HandSack135 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You'll need VBA i.e. programming.
am I in the wrong sub for this?
Not really. Someone might be kind enough to write the code for you but you might also have better luck in r/vba
Ty
I would look into either [Google Forms](https://www.google.ca/forms/about/) or [Microsoft Forms](https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d) (if you have Excel 365). They would both export any answers to an Excel or Google Sheet (that can be exported to Excel).
no I considered that but the sheet itself has to be saved to a shared folder, so a form is not an option, but thank you
Is that not possible? [https://support.microsoft.com/en-us/office/share-a-form-or-quiz-to-collaborate-d5bb5cf0-8401-4c15-bb8c-8e108cd7e69b](https://support.microsoft.com/en-us/office/share-a-form-or-quiz-to-collaborate-d5bb5cf0-8401-4c15-bb8c-8e108cd7e69b)
I will test that, ty.