View Single Post
  #1   Report Post  
tunabread
 
Posts: n/a
Default Transfer "Tabs name" to a worksheet


Hi everyone,

I have a little problem as I need to create many worksheet tabs in a
workbook everyday. How can I make a summary of all the tab names that I
have in this workbook to a worksheet? (so that I can check on my
progress daily)

Is there a formula or a little macro that can do this?

Eg. I have many tab names:
GR21550, GR21551, GR21553, GR21554,
GC35000, GC35001, GC35002, GC35004,
TR58690, TR58691, TR58692, TR58693,
TL18000, TL18002, TL18003, TL18004,
ZA8700, ZA8701, ZA8702, ZA8703, ZA8704etc....

Thanks and appreciate any help available!


--
tunabread
------------------------------------------------------------------------
tunabread's Profile: http://www.excelforum.com/member.php...o&userid=21561
View this thread: http://www.excelforum.com/showthread...hreadid=466578