You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
I have a worksheet with 45 different organisations. and 16 pivot based sheets that look at the original page.
I'd like to split the original page to get the data by each organisation.
And then select each new worksheet plus the 16 other pivot based sheets and create a workbook with new worksheet plus the 16 sheets.
The splitting is fine.
I'm guessing the select sheets and copy to a new book would require a for loop?