Hi, slightly tricky one... and maybe not excel related I have a spreadsheet with multiple tabs that lists the delivery schedule in different each on a separate tab. There are 4 tabs I think. I'm going to make a dashboard page that summaries the deliveries for this week in all states and then the boss wants it displayed on a separate monitor on the shelf above my desk so that my collegues can see it. I can get the extra monitor set up... but you can't really drag excel into a separate window like you can with MS word, so even using a separate file with a macro to pull the info out isn't really going to work. Only way I can think of is to print it to PDF after each major change and then open that file on the other monitor... any other ideas??