Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink trouble
I have in a workbook the worksheets ws1 and ws2. In A1 of ws2 I hold a hyperlink to a document on a network drive (let's name it doc1.doc) I need a funtion to polpulate A1 of WS1 with what it is in A1 of WS2, i.e. when I click on A1 of Ws1 to open the same document doc1.doc as when I click on A1 of ws2. I don't need to copy A1 of WS2 and paste it on A1 of WS1 (that works fine but that is not good for what I need). I need to type in A1 of Ws1 a formula that gives the same result as doing the copy and paste I mentioned before. Anyone can help? Thanks -- ticu ------------------------------------------------------------------------ ticu's Profile: http://www.excelforum.com/member.php...o&userid=35232 View this thread: http://www.excelforum.com/showthread...hreadid=550088 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Quickdoc imports to Excel 2003 hyperlink trouble | Excel Discussion (Misc queries) | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) |