I have created a very quick CMDB (Configuration Management Database) within Excel. It has different worksheets that refer to laptops, desktops, printers, etc. I want a front sheet that I can brand and also reference information from the different sheets. What is the easiest way to do this?
You could have totals of the number of Desktops, Laptops, Printers etc, totals of the different Windows versions...
All easy done with the COUNTIF's formula, then just design your images/layout around that for the front page? :)