listing all names in a worksheet

how can i list all the worksheet names in a master sheet?
is there a formula? an easy way??

Hi Tthe,

See responses to your earlier post(s).

---
Regards,
Norman



"tthe" <tthe@discussions.microsoft.com> wrote in message
news:001E6EA7-A9AD-44B4-A297-4D82B8B10F34@microsoft.com...
> how can i list all the worksheet names in a master sheet?
> is there a formula? an easy way??

Hi Norman
Sorry, I do not understand where I can get a solution for...
How do I get a list of all of the worksheets within a workbook in a single
‘summary’ worksheet. I have about 300 worksheets and do not want to link
each one, one at a time.
Many thanks
Simon

"Norman Jones" wrote:

> Hi Tthe,
>
> See responses to your earlier post(s).
>
> ---
> Regards,
> Norman
>
>
>
> "tthe" <tthe@discussions.microsoft.com> wrote in message
> news:001E6EA7-A9AD-44B4-A297-4D82B8B10F34@microsoft.com...
> > how can i list all the worksheet names in a master sheet?
> > is there a formula? an easy way??
>
>
>

Hi Simon,
I can't find a previous request in the last 5 days from the same author
as used in the thread, so don't know what the previous answers were.
You need a macro.

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Simon G" <SimonG@discussions.microsoft.com> wrote in message news:DD8B8E95-FB0C-4995-9816-D08CD49425F6@microsoft.com...
> Hi Norman
> Sorry, I do not understand where I can get a solution for...
> How do I get a list of all of the worksheets within a workbook in a single
> 'summary' worksheet. I have about 300 worksheets and do not want to link
> each one, one at a time.
> Many thanks
> Simon
>
> "Norman Jones" wrote:
>
> > Hi Tthe,
> >
> > See responses to your earlier post(s).
> >
> > ---
> > Regards,
> > Norman
> >
> >
> >
> > "tthe" <tthe@discussions.microsoft.com> wrote in message
> > news:001E6EA7-A9AD-44B4-A297-4D82B8B10F34@microsoft.com...
> > > how can i list all the worksheet names in a master sheet?
> > > is there a formula? an easy way??
> >
> >
> >

This excellent utility has a way to list all range names in a worksheet.

http://www.asap-utilities.com


"tthe" <tthe@discussions.microsoft.com> wrote in message
news:001E6EA7-A9AD-44B4-A297-4D82B8B10F34@microsoft.com...
> how can i list all the worksheet names in a master sheet?
> is there a formula? an easy way??