Updating multiple workbooks from a master workbook

(0) Share

Report

Posted on by ehhsmith

I would like to create a flow (automated, button, or scheduled) that parses one spreadsheet's rows into multiple spreadsheets.

Each week, I add rows in my master workbook that contains a list of visits to our campus service. These rows contain a student ID, student name, meeting time start, meeting time end, class title, and instructor name. I would like to each instructor to have his/her own workbook that is populated with only rows from my master workbook that contains their student's visit information.

I know it will involve "Add a row" but I have a hard time figuring out how to get the flow to recognize the correct workbook to add to based on the instructor.

Any help is appreciated!

All responses (2)

Answers (0)

ehhsmith 9 on at

Like (0)

Report

Re: Updating multiple workbooks from a master workbook

My tables are already defined in my master workbook, and tables with the same headers are already defined in the other workbooks I hope to connect.
Community Power Pla... on at

Like (0)

Report

Re: Updating multiple workbooks from a master workbook

You need to define a table first.

https://support.office.com/en-us/article/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370