Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Looking for a Macro or other tool to create a Workbook ContentSheet

David McRitchie has code and explanations he

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

(Second time today !!)

Hope this helps.

Pete

On Feb 7, 3:18*pm, "Victor" wrote:
i am looking for a possibility to create a sheet with the contents of al the
worksheets that are in the file you are working in.
Input for the sheet with contents would be a specific defined cell (let's
say the content is in Cell A1 of each worksheet) + the name of the tab of
the worksheet.


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
macro to find cell content in sheets and make sheet active Nigel Excel Discussion (Misc queries) 4 June 26th 14 02:38 PM
create personal macro workbook krispylala Excel Worksheet Functions 3 December 6th 07 04:38 PM
Macro to create new workbook and sheets Richard Excel Discussion (Misc queries) 1 July 31st 07 07:31 PM
Create link with sheet which is not inserted into workbook jai Excel Discussion (Misc queries) 1 April 17th 07 08:02 PM
Create link with sheet which is not inserted into workbook jai Excel Discussion (Misc queries) 2 April 17th 07 05:20 PM


All times are GMT +1. The time now is 06:54 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"