asish's blog

VBA Code for adding new Sheet based on cell value

Can anyone help me out to get the code for my below request.
I need to add new sheets in excel based on unique cell values of a particular column.
E.g. If I have a data of 1000 rows and in that the 1st column contains the month names. I need to run a macro so that the new sheets will get created in the same file with the specific month names along with their data.

Syndicate content