hi,
I am trying to make some rack diagrams in excel.
On sheet 1 I want to have a master overview of all my rack diagrams.
On sheets 2 onwards I want a detailed diagram of each rack.
For example on Sheet 2, in A1-A42 I will block off my rack units by using cell background colours, lines and text to show the various servers.
I will also include ip address details etc in B1-42
On Sheet 1, I want to see my lines, colours, text etc from only the Sheet 2 A1-42 cells. I don't want to see IP's etc.
I am sure this is possible, but being a bit of an excel noob I am struggling.
Any help appreciated
I am trying to make some rack diagrams in excel.
On sheet 1 I want to have a master overview of all my rack diagrams.
On sheets 2 onwards I want a detailed diagram of each rack.
For example on Sheet 2, in A1-A42 I will block off my rack units by using cell background colours, lines and text to show the various servers.
I will also include ip address details etc in B1-42
On Sheet 1, I want to see my lines, colours, text etc from only the Sheet 2 A1-42 cells. I don't want to see IP's etc.
I am sure this is possible, but being a bit of an excel noob I am struggling.
Any help appreciated