Mirroring data in another cell

Question

Level 1

15 points

Mirroring data in another cell

Hello,

I have duplicate data in two parts of my worksheet and I want to ensure that when I change it in one cell the duplicate also changes to the same value. I'm aware of using the "equals" original cell to do this for values but not sure it works with text?

Also, this works with individual cells, is it possible to duplicate a row of cells so that changing any cell will change the corresponding cell in the duplicate row in another part of the worksheet? I hope this is understandable!

Thanks,
Barry

Macbook, Mac OS X (10.4.11)

Posted on Oct 31, 2008 2:17 AM

Reply

Answer 1

Best reply

KOENIG Yvan

Level 8

41,807 points

Oct 31, 2008 2:42 AM in response to Barry Shortt

The 'equal' function apply also to text.
CAUTION: this function doesn't copy popup, checkbox, stepper or sliders but it copy their value .

In replica the row 1 is an header one.

In A1 enter:
=IF(OR(ISERROR(main :: A),ISBLANK(main :: A)),"",main :: A)
In B1 enter:
=IF(OR(ISERROR(main :: B),ISBLANK(main :: B)),"",main :: B)
In C1 enter:
=IF(OR(ISERROR(main :: C),ISBLANK(main :: C)),"",main :: C)
In B1 enter:
=IF(OR(ISERROR(main :: D),ISBLANK(main :: D)),"",main :: D)

Yvan KOENIG (from FRANCE vendredi 31 octobre 2008 10:40:09)

Reply

Answer 2

Barry Shortt Author

Level 1

15 points

Oct 31, 2008 2:57 AM in response to KOENIG Yvan

Thanks Yvan,

But, maybe I didn't explain it clearly. Say for instance I have row 1 with data in cells A1, B1 and C1. I want to duplicate those three cells in row 10 so A10, B10 and C10 reflect exactly what is in A1, B1 and C1.

Is there a way to do this without having to go to each of the individual cells on row 10 and "equalling" it to the corresponding cell in row 1.

My real rows have 40 cells each and if this is not possible then it would be quite tedious! Any help would be appreciated,

Barry

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Oct 31, 2008 4:08 AM in response to Barry Shortt

As far as I know, the equal formula is the only qoluce giving us 'living' cells.

Yvan KOENIG (from FRANCE vendredi 31 octobre 2008 12:08:54)

Reply

Answer 4

Oct 31, 2008 1:39 PM in response to Barry Shortt

Barry,

It isn't necessary to visit each cell in row 10. After typing =A1 into A10, hit return. Click once on A10 and it will be highlighted with a bold outline. There will by a tiny circle in the lower right corner of the cell. Click on this circle and drag it to the right as far as you want to duplicate the formula in a relative addressing way. That is, B10 will reference B1, C10 will reference C1, etc. This operation is called Fill. See the Help Topic: Autofilling Table Cells.

Regards,

Jerry

Reply

Answer 5

Barry Shortt Author

Level 1

15 points

Nov 1, 2008 3:54 AM in response to Jerrold Green1

Thanks Jerry,

As usual I was trying to make a mountain out of a molehill! It's simple and works perfectly,

Barry

Reply

Answer 6

KOENIG Yvan

Level 8

41,807 points

Nov 1, 2008 4:24 AM in response to Barry Shortt

As usual I was trying to make a mountain out of a molehill! It's simple and works perfectly,

As usual, looking in the PDF User Manual delivered with every copy of iWork would have spare time (page 66 in English version) 😉

Yvan KOENIG (from FRANCE samedi 1 novembre 2008 12:24:26)

Reply