List Of Sheet Names & Create Hotlinks for each one
 

Greetings,

I have a Workbook named STPData which contains 10-100 sheets Named STP with
Date and Time stamp such as (STP 10-25-04-09-55).
Is there a way to create a new Sheet named STPMain that automatically lists
all of the sheets and create a Hotlink to each one of them from the STPMain?.
The naming of the sheets can be modified to meet any scheme that may be
necessary to accomplish this and if possible to list the latest dates first.
In addition, if I can create a second sheet "STP Data Compare" that will
create column headers for each of the above sheets and copy below the header
the data from column B from each of the Sheets?.

Thank you in advance for your input.

List Of Sheet Names & Create Hotlinks for each one
 

Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SPYREN" schrieb im Newsbeitrag
...
Greetings,

I have a Workbook named STPData which contains 10-100 sheets Named
STP with
Date and Time stamp such as (STP 10-25-04-09-55).
Is there a way to create a new Sheet named STPMain that automatically
lists
all of the sheets and create a Hotlink to each one of them from the
STPMain?.
The naming of the sheets can be modified to meet any scheme that may
be
necessary to accomplish this and if possible to list the latest dates
first.
In addition, if I can create a second sheet "STP Data Compare" that
will
create column headers for each of the above sheets and copy below the
header
the data from column B from each of the Sheets?.

Thank you in advance for your input.

List Of Sheet Names & Create Hotlinks for each one
 

Frank,

Thank you for your timely response. The links you showed me are extremely
helpful and I have completed my tasks with a couple of minor problems witch I
will try to figure out today.




"Frank Kabel" wrote:

Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"SPYREN" schrieb im Newsbeitrag
...
Greetings,

I have a Workbook named STPData which contains 10-100 sheets Named
STP with
Date and Time stamp such as (STP 10-25-04-09-55).
Is there a way to create a new Sheet named STPMain that automatically
lists
all of the sheets and create a Hotlink to each one of them from the
STPMain?.
The naming of the sheets can be modified to meet any scheme that may
be
necessary to accomplish this and if possible to list the latest dates
first.
In addition, if I can create a second sheet "STP Data Compare" that
will
create column headers for each of the above sheets and copy below the
header
the data from column B from each of the Sheets?.

Thank you in advance for your input.