First time poster, long time creeper.
Using Excel 2010 on a W7 PC
I have an Excel sheet that is downloaded off of a SSRS portal. The SSRS report is formatted to be one page. When I print from there, each tab is printed on a single page.
But when the report is downloaded into Excel, it populates the data for every page on a tab (which is intentional and working fine), when I go to print it breaks each tab into 4 pages, with the last two columns on the right on page 3 and the 2 bottom rows on Page 2 and 4. So 30+ tabs each printing 4 pages. Should be 30+ tabs printing 1 page each.
I need a Macro that will hard code all of the tabs to fit on single pages. The tricky part is my tab names are not very consistent. The only consistent worksheet is 'Totals'. I tried one bit of code that copied the format of a specific tab and copied it throughout, but I could not get it to work.
Using Excel 2010 on a W7 PC
I have an Excel sheet that is downloaded off of a SSRS portal. The SSRS report is formatted to be one page. When I print from there, each tab is printed on a single page.
But when the report is downloaded into Excel, it populates the data for every page on a tab (which is intentional and working fine), when I go to print it breaks each tab into 4 pages, with the last two columns on the right on page 3 and the 2 bottom rows on Page 2 and 4. So 30+ tabs each printing 4 pages. Should be 30+ tabs printing 1 page each.
I need a Macro that will hard code all of the tabs to fit on single pages. The tricky part is my tab names are not very consistent. The only consistent worksheet is 'Totals'. I tried one bit of code that copied the format of a specific tab and copied it throughout, but I could not get it to work.
