Please note javascript is required for full website functionality.


Final Friday Fix: August 2019 Challenge

30 August 2019

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!