Hi,
I'm working on a sheet for mapping and showing dependencies between it systems. See attached worksheet for a simplified mock-up.
system dependencies.xlsx
The sheet maps systems with dependencies to other systems using the "System" column as a lookup table for the dependency columns.
The idea is that the sheet should filter or in some other way, clearly mark affected systems when one of the systems has its state changed to "down" so that the user can quickly gain an overview of which systems are affected.
I know I could probably go through all the dependency columns and filter according to the downed system, but it would be nice if this could be done in one action.
I'm thinking something along the lines of a macro or script that is triggered when the state is selected resulting in the filters being applied for all the dependency columns. However I'm not that much into Excel (yet) so I'm hoping for an easier solution.
Can this be done in Excel 2007 and if so how would you go about doing it - what tools or functionality would you use in Excel?
Cheers
Mark
Update: Replaced picture with worksheet
Bookmarks