Board Thread:General Discussion/@comment-27006659-20160418175659/@comment-27006659-20160502171059

Check out RR3_Project

https://www.dropbox.com/s/gmrt2z9u3jgtvzk/RR3_Project.xlsm?dl=0

Look at the Series Tab

Right click / refresh main table (columns A-E)

Column D is the worksheet names which conform to the Excel rules for tabs [30 characters, and no / or : characters ]

The Refresh Worksheet Names button copies column D to J, and removes duplicates

The Generate tabs button will create a new tab for each series

I think I had a solution to splittin the PR/Laps column, but I can't find it right now. Once I do, I'll post it here.

And if you didn't already know, there's a new version of Power Query, that'll allow multiple apends in one shot.

https://blogs.office.com/2016/04/26/more-april-2016-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/