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??
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??