Making new sheets with names from list ++

Hi,

First post here so... hi everyone


I have a list that goes from B6 to B206 that consists of Teig 001, Teig 002 and so on. This is in a sheet called TEIGER
I would like to have a way to create sheets with name based on the name of these cells.
I already have made Teig 001 manually and also want the new sheets to have the same content as that one.

In addition i would like the B2 cell in the new sheet to have the name of the new sheet..

And...(sorry to make it so complicated) I would also like that the list in TEIGER consists of hyperliks to the sheet with the same name....

I apologize for my poor english.

Anyone wanna give it a try?

Im not an excel expert, but i know of the macro function. But not the programming language

.
Or this which allows for blank cells in the list and provides hyperlinks :

Please Login or Register  to view this content.

Thank you so much. Tried mumps1's and worked great! thank you!

thank you also logit for you answer!

You guys saved me a great deal of work!!!

.
You are welcome.

erm. one more challenge.

I want to hide most of my sheets.... When i do so the hyperlinks dont work..

Any solution?


Thanks

Magne

.
Add this macro to the INDEX sheet module :

Please Login or Register  to view this content.

Then, if you desire to have the sheet (that you have hyperlinked to) auto hide when moving back to the INDEX sheet, include this macro in each of the sheets NOT NAMED Index:

Please Login or Register  to view this content.

.
You will do this one at a time for each sheet.

Right click on the sheet tab down the bottom. CLick on VIEW CODE

Copy and paste the macro into the large white window on the right (this is the area for the Sheet Level Module) :

Please Login or Register  to view this content.