Ask Your Question

How can I make an entry on sheet1 and make it appear on sheet 2 also?

asked 2018-05-17 22:08:55 +0100

abbrugger gravatar image

Want to transfer data to a different spreadsheet with one entry.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-05-17 22:38:20 +0100

erAck gravatar image

If you want something like carbon-copy then select sheet1 and sheet2 with Ctrl+LeftClick then write into a cell and close input with Alt+Enter. If that is not what you want then define your question more precisely.

edit flag offensive delete link more


Interesting. I didn't know that one. Just to clarify, because it's not specified in the original question: With this solution, if one entry is changed, the "carbon-copy" entries are not updated.

hjek gravatar imagehjek ( 2018-05-17 22:58:24 +0100 )edit

answered 2018-05-17 22:53:59 +0100

hjek gravatar image

The are a few ways of doing this.

Say you have a cell in worksheet called Sheet2 in which you want to refer to the cell A1 in Sheet1, then in the cell in Sheet2 you can enter =$Sheet1.$A$1

Another way is to give the cell, you want to share, a name. You do this by selecting the cell and in the name box (which is above the sheet to the left) enter the name foo. In another sheet you can refer to this name by entering =foo.

Also note that a name doesn't have to be just a single cell.

edit flag offensive delete link more


You may want to also try using, <copy>, <paste>, <paste special="">, <paste special=""> and then select <link> in the options section. This creates a link between the 2 cells, so whenerver you change the original cell, it is also changed in the 2nd location. This will work across different sheets Cheers

Ding Duck gravatar imageDing Duck ( 2018-05-17 23:15:44 +0100 )edit

What worked for me was: =Sheet1B2. No $ signs. Where B2 in sheet1 was copied to sheet2B6 where I wanted it. Thanks for the answer.

abbrugger gravatar imageabbrugger ( 2018-05-18 14:00:16 +0100 )edit

answered 2018-05-17 23:01:00 +0100

PaulaO gravatar image

Try the Help Menu.

Under references;to cells in other sheets/documents, it gives instructions.

TL;DR: Hjek is correct.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-17 22:08:55 +0100

Seen: 273 times

Last updated: May 17 '18