Forum Discussion
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...
Have you got a Microsoft 365 subscription? If yes, consider creating the form in Microsoft Forms. You can then create a Power Automate Flow, which takes the new entry and pushes the entered data into a table of an Excel file or even multiple tables in multiple Excel files if required. Sounds complicated maybe, but once you get the hang of this stuff it is a breeze to get data from others.