Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Table of Contents Sheet in Workbook
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.links
|
|||
|
|||
Table of Contents Sheet in Workbook
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 | |||
Table of contents Sheet with Hyperlinks | Excel Discussion (Misc queries) | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
Excel VBA Merge Workbook tables Central table | Excel Discussion (Misc queries) | |||
Using a cells contents to reference a sheet. | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) |