Need easy to do Hyperlinks in excel

Rick M · Apr 12th, 2002, 08:22 AM

I have a workbook with multiple sheets. I want to hyperlink (ex.. sheet1 cell B8 to sheet 2 cell B8 and then sheet 2 B8 to sheet 1 B8. This way I can add large comments related to each line.
The big problem is I have 334 rows I need to cross reference like this. It would take forever one at a time.
ANY IDEAS?

Chris Davison · Apr 13th, 2002, 07:54 AM

Quote:

On 2002-04-12 07:22, Rick M wrote:
I have a workbook with multiple sheets. I want to hyperlink (ex.. sheet1 cell B8 to sheet 2 cell B8 and then sheet 2 B8 to sheet 1 B8. This way I can add large comments related to each line.
The big problem is I have 334 rows I need to cross reference like this. It would take forever one at a time.
ANY IDEAS?

Hi Rick,

in sheet1 cell B8 :

insert
hyperlink
named location in file
browse
browse from : sheet name : B8
select sheet2
hit "ok"
hit "ok"

cell B8, sheet 1 should now display "sheet2!B8" in blue, underlined - ie your hyperlink

just copy and paste down your 344 rows

now you can type your comments in as and when. If however, you already have a list of comments, copy the comment range, right click your first hyperlink, paste special, values and the comments will become the actual link description (dunno if this is what you wanted)

repeat this process for sheet2 hyperlinking back to sheet1

By the way, if you try this process whilst reading this post, make sure the hyperlink wizard thing doesn't put this board's URL in the hyperlink box when it pops up : if it does, just delete it to blank at the end of the process.

_________________
Hope this helps,
Chris

edit - total time start to finish should be around 2 minutes

[ This Message was edited by: Chris Davison on 2002-04-13 06:56 ]

Rick M · Apr 29th, 2002, 07:03 AM

Thanks for the response Chris, however it doesn't work properly (if I did it right). the link says (sheet2!b8,sheet2!b9,etc....) but the link is always going to sheet2!B8 only?????

Chris Davison · Apr 29th, 2002, 12:29 PM

Rick,

you're right.... my apologies.

I remember testing this at the time but now can't find the file I used.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 08:22 AM	#1
Rick M New Member Join Date: Feb 2002 Location: Tampa, Fla Posts: 44	I have a workbook with multiple sheets. I want to hyperlink (ex.. sheet1 cell B8 to sheet 2 cell B8 and then sheet 2 B8 to sheet 1 B8. This way I can add large comments related to each line. The big problem is I have 334 rows I need to cross reference like this. It would take forever one at a time. ANY IDEAS?

Apr 29th, 2002, 07:03 AM	#3
Rick M New Member Join Date: Feb 2002 Location: Tampa, Fla Posts: 44	Thanks for the response Chris, however it doesn't work properly (if I did it right). the link says (sheet2!b8,sheet2!b9,etc....) but the link is always going to sheet2!B8 only?????

Apr 29th, 2002, 12:29 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Rick, you're right.... my apologies. I remember testing this at the time but now can't find the file I used.