Copying Multipe Rows to a New Sheet based on the Number entered into one cell from the master sheet
I am trying to create a copy workflow where the value of 1 cell in a particular row will let the system know how many copies I need in my new sheet. For example, My master sheet will have columns for company, department, location, etc. and another column which says "How many employees". If I enter in 5 into that "How many employees" column, in my new sheet, I want 5 rows that repeat the same company, dept, location, etc. and then I can fill out employee info in that new sheet. Does anyone know if that is possible? Thanks!