Hi all!
I am hoping someone out there has an excel formula or script that I can use to solve this problem:

I have a google form and I want the data from this form to go to different sheets (different workbooks) based on an answer to one of the questions. The trick is that the question may have more than one answer. The data collected includes metadata as well as files.

Alternatively, I would settle for an excel formula that would let me import data of a whole row, based on a partial match of information from one cell in a specific column.

Anyone have any ideas?

Best,

Mackenzie Salisbury (she, her, hers)<https://academicguides.waldenu.edu/diversity-inclusion>
Librarian, Digital Scholarship
Walden University Library<https://academicguides.waldenu.edu/library?utm_source=outlook&utm_medium=email&utm_campaign=email_signature>
<https://www.facebook.com/Walden-University-Library>

<https://www.facebook.com/Walden-University-Library>

<https://www.facebook.com/Walden-University-Library>[icon_facebook]<https://www.facebook.com/Walden-University-Library>  <https://www.instagram.com/walden.university.library/> [icon_instagram] <https://www.instagram.com/walden.university.library>   <https://twitter.com/WaldenULibrary> [icon_twitter] <https://twitter.com/WaldenULibrary>   <https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature> [icon_libnews] <https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature>