Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table of Contents (Exact match 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.worksheet.functions
|
|||
|
|||
Table of Contents (Exact match Hyperlinks?)
Assuming in Sheet2's A6 you have:
BOBSTABLE01 - Test for Usenet Help (note that the sheetname is assumed Sheet2, wo the space in between) and in Sheet1's A1, you have: BOBSTABLE01 - Test for Usenet Help Then in Sheet1, Put in say, B1: =HYPERLINK("#"&CELL("address",INDIRECT("'Sheet2'!A "&MATCH(A1,Sheet2!A:A,0))),INDIRECT("'Sheet2'!A"&M ATCH(A1,Sheet2!A:A,0))) This will produce a hyperlink in B1 which jumps to Sheet2's A6 when clicked Copy B1 down to return correspondingly -- 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table of Contents (Exact match Hyperlinks?)
I saw that in your main post and didn't realize the value in my
circumstance... THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Max wrote: Assuming in Sheet2's A6 you have: BOBSTABLE01 - Test for Usenet Help (note that the sheetname is assumed Sheet2, wo the space in between) and in Sheet1's A1, you have: BOBSTABLE01 - Test for Usenet Help Then in Sheet1, Put in say, B1: =HYPERLINK("#"&CELL("address",INDIRECT("'Sheet2'!A "&MATCH(A1,Sheet2!A:A,0))),INDIRECT("'Sheet2'!A"&M ATCH(A1,Sheet2!A:A,0))) This will produce a hyperlink in B1 which jumps to Sheet2's A6 when clicked Copy B1 down to return correspondingly -- 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table of Contents (Exact match Hyperlinks?)
You're welcome. Glad it worked for you.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Solusvir" wrote: I saw that in your main post and didn't realize the value in my circumstance... THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Sum Row Field Contents | Excel Discussion (Misc queries) | |||
Two column value match table look up | Excel Worksheet Functions | |||
Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
Table of contents for Charts | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions |