frantchoua@
Level 1
(4 points)
Q: How can I link different sheets in the same document ?
Hello (and sorry for my english, I hope, you'll understand my request),
Using Excel, I was used ton link several sheets one with another in the same document, using "paste special / paste with link" (not sure of the translation) and then "paste special / format". This was a fantastic tool, allowing me to have different aspects of my master sheet, all being updated automatically as soon the master one was changed. I was able to have up to 10 sheets in the same document linked to the master one, each containing what was strictly necessary for every single service I was working with.
I know I can have the same result on Numbers with cells, using "=" , but is there a way I can do it for an entire sheet ?
Thank you
MacBook Pro, OS X El Capitan (10.11.6)
SGIII
Level 6
(10,796 points)
frantchoua@ wrote:
I know I can have the same result on Numbers with cells, using "=" , but is there a way I can do it for an entire sheet ?
Try using = to address one cell on the other sheet. Then copy that formula right and down. That should have the same effect as selecting a range in Excel followed by Edit > Paste Special > Paste Link.
SG
