ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   new sheets..? (https://www.excelbanter.com/excel-programming/341231-new-sheets.html)

Hru48[_5_]

new sheets..?
 

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

--
Hru4
-----------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...fo&userid=2489
View this thread: http://www.excelforum.com/showthread.php?threadid=47109


dominicb[_139_]

new sheets..?
 

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


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


Ron de Bruin

new sheets..?
 
Hi Hru48

Is this the value of one cell ?

01 bob Brown

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hru48" wrote in message
...

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=471094





All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com