Automatic Sheet Adding through macro

Hi Friends

Am having a code which i got through my previous post that would automatically adds sheets and name them

Please Login or Register  to view this content.

[/CODE][/CODE]
I have tried the above code in my master sheets two issues i have faced

first one in my master sheet the category placed in B column i have changed the code according but the same not working
second one in the master sheet have having more than 1000 records in which the category 1 may come several no of times since the sheet named category 1 already created it is showing error msg

can you pls provide a code like this

having 12 default categories even it is present in the master sheet or not i want a sheet named category 1 ... so on
after that header of the file is same for the master sheet and the sub sheets hence the same needs to be updated in sub sheets also
then the datas in the master sheets automatically needs to copied to the sub sheets

can u pls help me with this

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Is this a continuation of this thread - http://www.excelforum.com/excel-prog...t-adding.html?

If yes, please continue in that thread itself by marking it unsolved. This thread will then be closed.