Forum Discussion
ingewashburn
Jul 18, 2022Copper Contributor
Excel form - trying to link sheets and autopopulate
I am creating a detailed form which combines specific questions from multiple insurance applications into one master application. I want to send this form to clients to fill out then copy the complet...
ingewashburn
Jul 19, 2022Copper Contributor
JKPieterse
Yes, I have MS365. Power Automate Flow sounds like a great idea! How dynamic is the form to excel process? I would need to input the data from the master-application to specific cells in other pre-formatted applications.
Yes, I have MS365. Power Automate Flow sounds like a great idea! How dynamic is the form to excel process? I would need to input the data from the master-application to specific cells in other pre-formatted applications.
Patrick2788
Jul 19, 2022Silver Contributor
I agree with JKPieterse 's recommendation.
If you want to have a look at forms to see if it will work for you, I'd start by going to your OneDrive. Select 'New', choose Forms Survey, and play around with building a form:
Initiating the form through OneDrive will link the responses to an Excel workbook automatically.