Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 16th 07, 05:26 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 3
Default How do I hyperlink to a specific cell in other excel worksheet?

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!

  #2   Report Post  
Old February 16th 07, 09:42 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default How do I hyperlink to a specific cell in other excel worksheet?

Select the cell you want to hyperlink to and give it a name (Insert - name)
and then you can hyperlink to it.

Mike

"Yasna" wrote:

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!

  #3   Report Post  
Old February 16th 07, 11:41 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default How do I hyperlink to a specific cell in other excel worksheet?

You can hyperlink to any cell in any sheet in your workbook:

Insert Hyperlink... Place in this Document

then supply either the reference cell or a Named Range.
--
Gary's Student
gsnu200706


"Yasna" wrote:

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!

  #4   Report Post  
Old February 16th 07, 04:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 3
Default How do I hyperlink to a specific cell in other excel worksheet

Thanks Mike,

I want to have the value of the formulated cell in another worksheet
displayed (via hyperlink) in another worksheet...possible?
If this is possible please go step by step.
Thanks,


"Mike" wrote:

Select the cell you want to hyperlink to and give it a name (Insert - name)
and then you can hyperlink to it.

Mike

"Yasna" wrote:

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!

  #5   Report Post  
Old February 16th 07, 07:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default How do I hyperlink to a specific cell in other excel worksheet

Yasna

I don't think you want a hyperlink.

All you need is a link to the other cell.

=Sheet2!A1 entered in a cell on Sheet1 will return the value.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 07:47:58 -0800, Yasna
wrote:

Thanks Mike,

I want to have the value of the formulated cell in another worksheet
displayed (via hyperlink) in another worksheet...possible?
If this is possible please go step by step.
Thanks,


"Mike" wrote:

Select the cell you want to hyperlink to and give it a name (Insert - name)
and then you can hyperlink to it.

Mike

"Yasna" wrote:

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink to a specific worksheet Roger Excel Discussion (Misc queries) 2 November 1st 06 04:25 PM
Hyperlink button to a specific cell in excel JayWes Excel Discussion (Misc queries) 1 July 21st 05 11:21 PM
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 07:01 PM
hyperlink an excel cell to a specific location wthin application f dirtboy New Users to Excel 1 January 17th 05 09:07 PM
hyperlink an excel cell to a specific location wthin application f dirtboy Excel Discussion (Misc queries) 0 January 17th 05 09:03 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017