LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
copying worksheet tabs Lynn Excel Discussion (Misc queries) 1 March 18th 05 05:50 PM
How do I automatically transfer data to a 2nd worksheet page? BarrelRacer Excel Worksheet Functions 1 March 15th 05 09:52 PM
How do I make Excel worksheet tabs change appearance when chosen . fentrkn Excel Discussion (Misc queries) 1 March 14th 05 05:36 PM
Tabs Inside of a worksheet havocdragon Excel Worksheet Functions 2 November 24th 04 09:19 PM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"