Is there a simple, elegant way to copy rows with linked cells to another sheet?
In my specific case, I have a summary sheet where each project has one row with data linking from a detailed project plan sheet (e.g. - Dates, Budget Hours, % Complete, etc...). I want to copy rows to another sheet where I will be creating Card views for specific sub teams. I want the data to be dynamic as changed only in the detailed project plan sheet. Using a simple automation and copying rows as they are added to the summary sheet does not maintain linked cell connections to the detailed project plans - just static data. Is there an elegant solution to this dilemma? Thanks!
Help Article Resources
Check out the Formula Handbook template!