I have created a very quick CMDB (Configuration Management Database) within excel and 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. Can somebody advise me 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? :)