How To Have Excel VBA Create Sheets Based On A List

This code with use VBA to create sheets based on a list of names.

In the following image, we have a data sheet listing names in column B. We want to create sheet names based
on the names in that column.

Make sure your Excel spreadsheet is saved as an .xlsm and accepts macros.

In the VBE, add a new module and type the following:

When you press F5, and run the code, you’ll find the newly created sheets!

We could have done more than 3 but that’s a good example.

Let me know if you have any questions.


Please remember to subscribe to my youtube channel

Been helped? Get these!