Forum Discussion

Brad_Beith's avatar
Brad_Beith
Copper Contributor
Jun 16, 2020

Converting an excel worksheet with page breaks to a document with separate tabs/worksheets

Hello!  I have an Excel doc that has one worksheet with about 15 page breaks.  I'd like to convert that one sheet with page breaks into 15 different worksheets (instead of page breaks).  Is this possible?  Thank you!

  • BradD's avatar
    BradD
    Brass Contributor
    Yeah, all possible with VBA. The question is though, is VBA an approach you’d entertain?

Resources