Forum Discussion

Sherouk Saleh's avatar
Sherouk Saleh
Copper Contributor
Nov 13, 2018

Printing with excel

Hello everyone,

 

I need help with this issue.

I have multiple worksheets (books) which i need print the 2nd page of each together. without having to open every workbook to print the 2nd sheet alone. 

 

I have around 150 workbooks!

 

Thanks 

excel
Macros and VBA
  • Willy Lau's avatar
    Willy Lau
    Steel Contributor
    Nov 15, 2018
    May I know if you use the same format for the sheets in these 150+wbks?
    • Sherouk Saleh's avatar
      Sherouk Saleh
      Copper Contributor
      Nov 16, 2018

      yes they are all the same format. and all have 1st sheet customer info, 2nd sheet statement, 3rd invoice etc. 

Resources