I need a dashboard that feeds from an Excel SS. I want it to look like the Stock Exchange ticker, (small enough to run at the bottom/top of the screen.
Check out [login to view URL] for an example. Look at the live dashboards "Executive Scorecard", only the top ticker not the rest. Another example is under "Aging Summary", at the bottom of the screen. I don't need it to drill down to deeper data, just stream the results of the SS. I need to be able to copy the code to many different sheets and reference different ranges of cell. I have attached an Excel SS that I would like the dashboard to pull data from. The ticker would display Cell A7,K7,and L7, then the next box would be A8,K8, and L8, and so on until the cell is blank. Note the color/conditional format for positive and negative numbers. The idea is to open the spread sheet that feeds from SQL, start the dashboard then minimize the excel and just let the dashboard run at the top or bottom of the screen.
Flexabilty is key, I need to be able to apply this to deparmental numbers for the managers, and full enterprise numbers for the Executives.