Can I link to aonther cell in the same spreadsheet?

Mer · Newbie Joined: 20 Apr 2007 Posts: 4

Hi,

I need to link a cell to another cell in a different sheet within the same spreadsheet.

Can this be done and if so, how?

Thanks for any help,

Eric

squenson · Posted: Fri Apr 20, 2007 11:52 am Post subject:

Mer,

Use the dot as separator, try <your_sheet>.<your_cell>, example Sheet2.C23
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<

Mer · Newbie Joined: 20 Apr 2007 Posts: 4

Didn't work,

Here's what I'm trying:

=HYPERLINK("[OutlineDrawings.xls]Sheet4.A5","O-1261")

I'm just getting started in spreadsheets so I'm sorry in advance for the questions.

I'm in Sheet1 named Outline Drawings. The name of the spreadsheet is OutlineDrawings.xls.

I want to link the text in a cell in Sheet1 to cell, A5 in Sheet4.

Thanks,

Eric

squenson · Posted: Fri Apr 20, 2007 12:05 pm Post subject:

Eric,

If you type in cell A1 oh Sheet1:

Mer · Newbie Joined: 20 Apr 2007 Posts: 4

Didn't work, sorry.

Right now in cell A293 is: O-1261

I want that text to link to cell A5 in Sheet4 so when I click on the O-1261 it will take me to cell A5 in Sheet4.

Thanks,

Eric

squenson · Posted: Fri Apr 20, 2007 1:01 pm Post subject:

Now I understand your question!

Select the source cell, type

Mer · Newbie Joined: 20 Apr 2007 Posts: 4

Thank You!!

Eric

dgrgic · General User Joined: 23 Apr 2007 Posts: 10

This helped. Thank You.
But this is an absolute address and will not point to right place if destination cell is moved (with insert row or similar).
Do u have alternative solution that will take this into account as well?!

Tnx again,
Damir

santosog · Newbie Joined: 10 May 2007 Posts: 1

Define a name to the cell and create a hyperlink to the cell name instead of the cell row and column.

=HYPERLINK("#cellname";"O-1261")

Hope this helps.

dgrgic · General User Joined: 23 Apr 2007 Posts: 10

It did tnx.