Connect Two Cells
 

Dear Experts,

In sheet 1 A1, I typed "See details". I want when this wording is pressed,
it will then go to sheet 2 B3 and this cell is selected. This action is just
like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two cells
will not be changed. Is it possible? If yes, how can I do it? Please kindly
advise.

Thanks in advance

Connect Two Cells
 

You can use a hyperlink function:

Instead of typing "See details" in the cell enter this formula in cell A1:

=HYPERLINK("#Sheet2!B3","See Details")

Now, just click on "See Details" and it will take you to Sheet2 cell B3.

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
Dear Experts,

In sheet 1 A1, I typed "See details". I want when this wording is pressed,
it will then go to sheet 2 B3 and this cell is selected. This action is
just
like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two
cells
will not be changed. Is it possible? If yes, how can I do it? Please
kindly
advise.

Thanks in advance

Connect Two Cells
 

Hi Biff,

Thanks for your great help. It works perfectly. Thanks once again. Cheers!

"T. Valko" wrote:

You can use a hyperlink function:

Instead of typing "See details" in the cell enter this formula in cell A1:

=HYPERLINK("#Sheet2!B3","See Details")

Now, just click on "See Details" and it will take you to Sheet2 cell B3.

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
Dear Experts,

In sheet 1 A1, I typed "See details". I want when this wording is pressed,
it will then go to sheet 2 B3 and this cell is selected. This action is
just
like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two
cells
will not be changed. Is it possible? If yes, how can I do it? Please
kindly
advise.

Thanks in advance

Connect Two Cells
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
Hi Biff,

Thanks for your great help. It works perfectly. Thanks once again. Cheers!

"T. Valko" wrote:

You can use a hyperlink function:

Instead of typing "See details" in the cell enter this formula in cell
A1:

=HYPERLINK("#Sheet2!B3","See Details")

Now, just click on "See Details" and it will take you to Sheet2 cell B3.

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
Dear Experts,

In sheet 1 A1, I typed "See details". I want when this wording is
pressed,
it will then go to sheet 2 B3 and this cell is selected. This action is
just
like linking sheet 1 A1 to go to sheet 2 B3 and the value in these two
cells
will not be changed. Is it possible? If yes, how can I do it? Please
kindly
advise.

Thanks in advance