Creating and Renaming New worksheets?

[tonylyx]

Hi everyone,

I have a column of names from B8 to B52 in a worksheet called "MasterList", I would like a macro that helps me create 44 new worksheets and Name them (1 for each of the values in the cells B8, B9, B10 etc.
Eg. If B8 has the value Apple, B9 has the value Orange, I would like the new sheet to be name Apple, the second new worksheet to be named Orange and so forth..

Any help would be greatly appreciated!

Thank you

[tigeravatar]

tonylyx,

Give this a try:

Please Login or Register  to view this content.

[tonylyx]

That works perfectly, Repped! Thank you tigeravatar

[Jakobshavn]

Select the MasterList worksheet and run this small macro:

Please Login or Register  to view this content.