MS Excel Tip — VBA to Create Worksheets from List of Names
One of my frequently used techniques — small, but effective!
Published in
1 min readJan 24, 2019
I take for granted many of the #Excel “tricks” and #macro snippets I use everyday.
And I inevitably get an “aha” moment from a client when one comes into play in a project.
So, I am going to get better about sharing my “secrets”.
Today it’s creating a group of Excel sheets in batch from a list in Excel. I use this frequently to shell out “placeholder” sheets when developing a large workbook.
These “tricks” are small improvements, but they really add up over time!
If you want to play with a sample workbook, you can download it here.
Do you have any favorite automation tips to share?
