If one day your manager hand you an Excel file and ask you can you create worksheets for each of the company list in a column, and you see that there are approximately 100 items. And image if you have to create them one by one for a 100 times, that must be a super daunting task. Same with deleting worksheets.

In this tutorial, I will show you how we can write a simple VBA script to automate the manual work so you don’t have to do them manually by hand.

VBA Script