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

Copper Contributor

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!

1 Reply
Yeah, all possible with VBA. The question is though, is VBA an approach you’d entertain?