#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default list of sheets

I have file with many sheets, can I create a content of them?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default list of sheets

"svko" wrote:
I have file with many sheets, can I create a content of them?


Aha, you're looking to build a table of contents ?

One good way is Jim Cone's fine, free product (his XL Extras add-in) at his:
http://www.realezsites.com/bus/primi...e/products.php

Scroll right down to the bottom of the page for the download link:
XL Extras - release 1.19 ... Download
A collection of additional features including...
**create table of contents with hyperlinks to each sheet

Jim's add-in will do exactly what you're looking for (and much more ..)
After installing, just click Insert Table of Contents, then sit back
and watch Jim's magic go to work <g !

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply
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
Create a list of data from same cell but different sheets Eddie P Excel Discussion (Misc queries) 2 May 19th 06 08:01 PM
linking data between sheets using drop down list JohnOC Excel Worksheet Functions 4 March 13th 06 04:25 PM
How to Change List Based on Value Chosen in Another List Edwin Kelly Excel Worksheet Functions 4 March 2nd 06 07:31 PM
Matching Lists Where List Size is Unequal zgall1 Excel Discussion (Misc queries) 1 February 16th 06 11:21 PM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM


All times are GMT +1. The time now is 10:11 AM.

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"