We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

importing numbers from a separate worksheet

asked 2021-05-12 00:55:26 +0200

How do I import numbers from one worksheet to another so that when the numbers change on the the one the number is changed on the other?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2021-05-13 19:05:58 +0200

erAck gravatar image

Use external cell references, either type in the form

='file:///home/user/filename.ods'#$Sheet1.A1

or see the help section To Reference a Cell in Another Document for how to do it by a more cumbersome point and click.

Note that you can pull / copy&paste such reference just like any other reference and the relative reference parts will be adjusted.

Values are updated when the current document is reloaded (after request) or upon manually updating linked values (Edit -> Links to External Files...). Additionally values are updated if you have the other (source) document loaded as well and edit it, but only when the formula cell is recalculated; e.g. depending on a to be recalculated cell as well, or hitting F9 on it, or Shift+Ctrl+F9 for a hard recalc of the entire document.

edit flag offensive delete link more

Comments

Thank you so very much for your help

jim_sorensen_80233@yahoo.com gravatar imagejim_sorensen_80233@yahoo.com ( 2021-05-14 00:22:57 +0200 )edit

Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.

erAck gravatar imageerAck ( 2021-05-14 19:31:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-05-12 00:55:26 +0200

Seen: 23 times

Last updated: May 13