Hey guys,

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

so:

01 bob Brown
07 Jim Scott
11 Dave John

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

Any Ideas anyone?


Cheers

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471093

Good afternoon Hayley

Do you want to create a number of sheets that are to be named according
to the contents of cells? If so, then use this routine:

Sub SheetName()
For Each UsrCell In Selection
Sheets.Add.Name = UsrCell.Value
Next UsrCell
End Sub

Highlight the range of cells you want to use as the base, and then run
the macro.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471093

Thats grand, but how do i get it to run until the list is empty?


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471093

Okdookie,

So I have my sheets, how do I make them so they have a template on
then?

The same information on all of them in the same place..?


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471093

Hi HRU48

Not quite sure what you mean here. You're going to have to expand on
that.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471093

ok, at the minute I have the macro creating new and empty sheets, how
can i get it to create sheets with an applied style? say... is cell A1
i have the word bob etc?

and much thanks for you help so far!


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471093