View Single Post
  #1   Report Post  
Willis
 
Posts: n/a
Default Multiple Print Ranges on one Worksheet

I've got a worksheet that has two columns for each month going out
three years some subtotals at the far right. Depending on who the
audience is, I need to print 12 months to a page (landscpae 3-pages) or
do a single page summary (portrate one page). Is there a way that I can
save my page layout and quickly switch between the two? I can't put the
summary data on a seperate tab (per my bosses request). I want to find
a way to save the page layout and print options and toggle between the
two.