Share
Report
6Hi all, looking for any advice on creating a flow to auto update a cell and auto print another tab within the same excel document.
The details of the current situation:
1. I have an excel file connected to a MS Form (which includes questions like name/address etc etc ).
2. As responses are received into excel from Forms (into tab named FORM1), the user manually enters the response ID into cell D1 on FORM1.
3. There is a separate tab (named DOCUMENT) that is linked to D1 of FORM1, and through formula in DOCMUENT, as the ID# is updated in D1/FORM1, all the individual answers for that particular response are automatically updated and create a client facing document that is then manually printed.
What I would like to create:
The above process is manual, so I would like to create a flow that as each response is recorded in Excel, the ID is automatically populated into cell D1 of FORM1 and then the tab named DOCUMENT is printed.
Is something like this possible, or too complicated??
Greatly appreciate any assistance you can provide!
All responses (
Answers (
