Excel should let me link one cell to another.
 

I would like to be able to create a link in one cell that, when clicked, will
transfer me to another cell in the workbook. It is similar to linking
footnotes in a webpage. Suppose I am collecting data and I want to make a
note about an entry and I will be making several notes throughout the course
of the project, I would create a worksheet at the end of the workbook titled
"Notes" and I would list each note separately. I would like to create a link
called "See Notes" or "See Note 1(,2,3,...)" in the cell. When I click on
this link, it will transfer me to the "Notes" worksheet. On many webpages,
they will place a # sub- or super-script after a sentence to indicate a
footnote. When you click this #, you are directed to the corresponding
footnote elsewhere on the webpage. This is what I want to be able to do
within the workbook.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Excel should let me link one cell to another.
 

You can, use insert hyperlink and select "place in this document".

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Niagara_Falls" wrote in message
...
I would like to be able to create a link in one cell that, when clicked,
will
transfer me to another cell in the workbook. It is similar to linking
footnotes in a webpage. Suppose I am collecting data and I want to make a
note about an entry and I will be making several notes throughout the
course
of the project, I would create a worksheet at the end of the workbook
titled
"Notes" and I would list each note separately. I would like to create a
link
called "See Notes" or "See Note 1(,2,3,...)" in the cell. When I click on
this link, it will transfer me to the "Notes" worksheet. On many
webpages,
they will place a # sub- or super-script after a sentence to indicate a
footnote. When you click this #, you are directed to the corresponding
footnote elsewhere on the webpage. This is what I want to be able to do
within the workbook.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions