new sheets..?

[Hru48]

Hey guys,

I have a list of names and I need the number of names in that list t
be the number of automatically generated new sheets, each named
different number.

so:

01 bob Brown
07 Jim Scott
11 Dave John

would become three different sheets, the first one named on the botte
tab 01, the second - 07 and the third 11.

Any Ideas anyone?


Cheers

Hayle

 

[dominicb]

http://www.excelforum.com/showthread.php?t=471093

 

[Ron de Bruin]

Hi Hru48

Is this the value of one cell ?

01 bob Brown