Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / August 2006

Tip: Looking for answers? Try searching our database.

Table of Contents Sheet in Workbook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Solusvir - 30 Aug 2006 18:39 GMT
I have two sheets in my workbook.

One has a listing of table headers like:

BOBSTABLE01 - Test for Usenet Help (Cell A1, Sheet 1)

The second sheet contains the same header followed by details of the
file:

BOBSTABLE01 - Test for Usenet Help (Cell A6, Sheet 2)
FROM    TO      FIELD NAME
1       1       XXXXXXX
2       26      XXXXX
27      36      XXXXX
37      40      XXXXXXX
41      44      XXXXX
45      45      XXXXXXXX
46      55      XXXXXX
56      59      XXXXX
60      63      XXXXXXX

I would like to create a hyperlink from sheet one which would direct me

to the correct info on sheet two. I can do this manually but it is very

time consuming(1,590 links), is there a way to write a code that will
look for an exact match from sheet one to sheet two and hyperlink it?
Max - 31 Aug 2006 09:47 GMT
See one response to your multi-post in .worksheet.functions
(Please do not multi-post)
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have two sheets in my workbook.
>
[quoted text clipped - 23 lines]
> time consuming(1,590 links), is there a way to write a code that will
> look for an exact match from sheet one to sheet two and hyperlink it?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.