List worksheet names in a seperate sheet

[Mike K]

Oh Wise Ones

HR has a workbook that they add worksheets to and manually name them,
beginning withe either "AC" or "NM" (accident or near miss). I have a sheet
named "Control" that has code to count the number of worksheet by prefix.
Could I have a dynamic range on that sheet that lists the "names" of the
worksheets in a column? And if its not too much more difficult, dynamically
link to the specified sheet?

Mike

 

[Jim Cone]

A couple of options in this post...
http://tinyurl.com/2y2k56
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Mike K" <[email protected]>
wrote in message
Oh Wise Ones
HR has a workbook that they add worksheets to and manually name them,
beginning withe either "AC" or "NM" (accident or near miss). I have a sheet
named "Control" that has code to count the number of worksheet by prefix.
Could I have a dynamic range on that sheet that lists the "names" of the
worksheets in a column? And if its not too much more difficult, dynamically
link to the specified sheet?
Mike

 

[Mike K]

Thanks Jim! XL Extras works pretty slick.

Note my new post on automating worksheet indexing.

Mike