Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of contents Sheet with Hyperlinks
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table of contents Sheet with Hyperlinks
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: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 sheet and build table | Excel Discussion (Misc queries) | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
how can i secuire Sheet Same time Update the Pivot Table | Excel Worksheet Functions |