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!
