Ask Your Question
1

how can i make a cell linkable to another spreadsheet

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

Porthos 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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 65 times

Last updated: Sep 01 '18