Ask Your Question

how can i make a cell linkable to another spreadsheet [closed]

asked 2018-08-30 18:38:55 +0200

Porthos gravatar image

updated 2020-08-02 11:17:35 +0200

Alex Kemp gravatar image

I have 300+customers in calc master list. i want to be able to click on 1name and have it linked to a spreadsheet that shows that customers purchasing activity

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 11:18:09.468043

2 Answers

Sort by » oldest newest most voted

answered 2018-09-01 18:08:28 +0200

gtomorrow gravatar image

You could try hyperlinking each name to its document with one of two methods.

In the cell containing the name in your master document you could enter the formula =HYPERLINK("file:///path/to/your/client/document.ods#Sheet1.A1","yourClientName") Change the path to point to the pertinent file and target, and likewise the client's name.

Otherwise, select your name cell, Insert Hyperlink (Ctrl/Cmd-K) and enter the file location including any necessary targets (e.g., "#$Sheet1.$A1").

I realize you're dealing with 300+ entries and possibly, like @Mark McLean suggested, a macro would be more efficient. It's your call. Good luck!

edit flag offensive delete link more

answered 2018-08-30 20:59:36 +0200

If I am understanding!? Enter = where you want results to show, and than just go to whatever sheet/cell you want and hit enter.

edit flag offensive delete link more


I do that to update the running total from the detail list to the master list. What I need is for me clicking on the name cell the link takes me to their history page - not just a cell

Porthos gravatar imagePorthos ( 2018-08-31 15:47:13 +0200 )edit

Oh, I do such with macro assigned to a button. I don't know how one could do such by clicking a cell.

Mark McLean gravatar imageMark McLean ( 2018-08-31 17:53:56 +0200 )edit

Question Tools

1 follower


Asked: 2018-08-30 18:38:55 +0200

Seen: 124 times

Last updated: Sep 01 '18