Challenges: Final Friday Fix: August 2019 Challenge

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!

This month’s Final Friday Fix involves the automating the generation of multiple worksheets from a data list. In our challenge for this month, we have a data list that contains the names of the worksheets that we are going to create, as shown below:

We need to create multiple worksheets with the names shown in the data list above, so that the result will look like this:

We want to automate this process without manually adding each worksheet and changing the worksheet name individually. Sounds like a job for VBA this month.

Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the mean time!