Ask Your Question
0

Referencing a Cell in Another Sheet in CALC

asked 2015-02-18 23:15:50 +0200

steve.leach.549 gravatar image

I have a calc file with 201 sheets, the 201st is called Totals. I would like to display the contents of a cell from the Totals sheet .... for example, in Sheet 1, I want the contents of cell G1 of the Totals sheet. In Sheet 2, I want the contents of cell G2 in the Totals sheet. The closest I can come up with is >

=Totals.G&"Sheet()"

Haven't been able to figure it out. Thanks!

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted
0

answered 2015-02-19 09:26:30 +0200

karolus gravatar image

updated 2015-02-19 09:28:04 +0200

@m.a.riosv : think twice over stuff with INDIRECT(ADDRESS...

The answer is
=INDIRECT("Totals.G" & SHEET())

edit flag offensive delete link more

Comments

I would add that if you want the result to the same position in all the sheets you can select sheets before entering. Steps to Reproduce:

  1. Click on the tab of the first sheet
  2. Shift + Click on the last sheet tab (before "Totals")
  3. Click in the cell where you want the result and then enter the formula given by mariosv
pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-02-19 09:47:07 +0200 )edit
0

answered 2015-02-19 12:54:56 +0200

steve.leach.549 gravatar image

Thank you very much - perfect!

edit flag offensive delete link more

Comments

Delete this answer !

rautamiekka gravatar imagerautamiekka ( 2015-02-20 13:53:24 +0200 )edit
0

answered 2015-02-19 01:19:26 +0200

m.a.riosv gravatar image

updated 2015-02-19 01:20:27 +0200

Try with a formula like: =INDIRECT(ADDRESS(SHEET();7;1;1;"Totals");1) It takes the row number from SHEET() which gives the sheet number, ADDRESS() gives the address as text and INDIRECT() returns the value for text address.

edit flag offensive delete link more
-1

answered 2015-02-19 01:30:18 +0200

updated 2015-02-19 01:32:15 +0200

Trying my luck: put ='Totals'.G2 to the cell you want something to appear in. That's how Google converted a spreadsheet from their own format to ODS and it worked just fine when I changed some values.

edit flag offensive delete link more

Comments

@rautamiekka: did you read and understand the question ??

karolus gravatar imagekarolus ( 2015-02-19 09:32:21 +0200 )edit

@karolus: I could had misunderstood it.

rautamiekka gravatar imagerautamiekka ( 2015-02-20 13:53:45 +0200 )edit
Login/Signup to Answer

Question Tools

Stats

Asked: 2015-02-18 23:15:50 +0200

Seen: 4,724 times

Last updated: Feb 19 '15