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!
