Create new row based on condition

Occasional Visitor

Hi everyone,


I'm relatively new to Excel and am currently trying to create a document that contains a master sheet with company projects, and then sub sheets based on location which auto-populate based on two conditions, project location and project status. 


The auto-populate formula is up and running, but I'm wondering if there's any way to make the sub sheets automatically create a new row underneath whenever any data is auto-populated from the master? 


Would be very helpful if anyone knows what could be done, thanks in advance!

0 Replies