Forum Discussion
help with formulas for connecting 2 workbooks & connecting the sheets within it to sync new entries
i need help "linking" or connecting a sheet in 1 work book to 1 in another workbook the first workbook is a excel sheet of microsoft forms responses with the exact same column headings as the form o...
I don't think that's possible without restructuring of Notes file. In general, each new response is automatically added to Form Responses. In addition you may use Power Automate triggered on each new response which adds the record to this or that sheet into another file depends on response content. Not easy task, but possible.
With that in sheets shall be structured tables which has nothing but collected responses.
Perhaps it's more productive to use only Form Responses file. Sheet with responses could be hided from end users, you may add another sheet with data preparations based on responses sheet, and finally reporting sheet.
Not sure that could be done fast. Depends on logic, what is desired output. IMHO, that's definitely doesn't work with Notes file as it is now.