How to link multiple cells, on multiple projects with ease
I'm managing 71 construction projects. I use one sheet per project site to track 182 (start, finish, and "actual complete") tasks that vary, per project scope. (546 date cells per project)
I'm needing to run multiple reports, containing all projects, with abilities to sort, add date altering functions like ("Cell" -30d), conditional formatting for status, multiple filtering options, and cross sheet vlookup,
This is for client needs, my accounting team, and much more.
I've found a way to accomplish this with a combination of thousands of manual cell links, and vlookup functions to sneak under the 5000 link restriction, but the time consumed with the manual linking, makes it an infeasible option.