Table of Contents Sheet in Workbook "Solusvir" <Solusvir[ at ]gmail.com> 30.08.2006 17:39:14 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?

Re: Table of Contents Sheet in Workbook Max 31.08.2006 08:47:01 See one response to your multi-post in .worksheet.functions (Please do not multi-post) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Solusvir" wrote: [Quoted Text] > 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? > >