You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

IMPORTRANGE ON NUMBERS

Hello! Recently I am trying to mov to Numbers from Google Sheets, but i have a trouble.


I need to import some columns from one table to another. I know I could just copy this column, however these are values ​​that change constantly and having the possibility to import these values ​​from one table to another automatically makes my life much easier.


Is this possible on Numbers sheets?


thanks


Luciana

iPhone 11, 13

Posted on Aug 7, 2020 7:13 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 7, 2020 9:08 AM

Don’t think you can “import” a whole column at once, but in the destination table you can “import” a value from a cell in another table by typing = to call up the formula editor then navigate to the source table and click a cell there and hit <return> to accept. If the two tables are structured the same way and you won’t be inserting rows in the source table then you can fill the formula down the column in the destination table.


Usually it’s better to avoid having the same data in multiple places, though.


SG

1 reply
Question marked as Top-ranking reply

Aug 7, 2020 9:08 AM in response to luciana_medeiros

Don’t think you can “import” a whole column at once, but in the destination table you can “import” a value from a cell in another table by typing = to call up the formula editor then navigate to the source table and click a cell there and hit <return> to accept. If the two tables are structured the same way and you won’t be inserting rows in the source table then you can fill the formula down the column in the destination table.


Usually it’s better to avoid having the same data in multiple places, though.


SG

IMPORTRANGE ON NUMBERS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.