I cannot include the formula in the template as the copy over just replaces it. One of the columns however in the main workbook has a formula in it and when the split occurs the formula now points to the original workbook instead of the new workbook. loop until all managers in column as list has been processed. open template workbook > copy rows that equal first manger as column as list > save template as new nameģ. open main workbook > find manager column as list > remove duplicateĢ. Therefore the flow at a very high level is.ġ. I use a template workbook and the data is formatted as a table. This results in separate workbooks only containing the employees that report to that specific manager. I am running a flow that is splitting a large workbook into several smaller workbooks by using the manager name as the qualifying criteria. I am using power automate desktop on windows 10 with office 365
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |