Numbers Table Aliases

I'd like to be able to create a table which simply points to the data in an existing table. This way I could spin off multiple tables from one set of data showing different content via filters. Of course it needs to be dynamically updated, I only want to edit the data in the "master" table, the others would be "read-only".

Posted on Oct 21, 2020 6:07 PM

Similar questions

How to display specific columns from one table to another? I am trying to develop a table that shows the first and latest data from another table. The display table is where I want the data placed. The data table is the table where I enter the data. I'd also like to make a 'Data Entry Table' that allows me to enter specific data that would automatically sent the data to the first blank column on the data table. Any idea on how to do this?? Thanks!
369 5
Numbers : Tables within tables I would love this feature. I'm using Numbers for financial analysis of different equities. Each tab is a different equity, and the same table is used within each tab. There is a lot of text within the cell of these tables, and sometimes it would be good to be able to insert a table with data within one of the cells. I know this sounds like i'm using Numbers differently, i.e. not to crunch numbers but rather to display data, but there is no better software which seems to be better suited. Thanks
610 4
How to select a table in Numbers I need to transpose columns into rows. I see I need to first select my table to do this. I do not know how to select a table. I have copied the advice given on the Numbers troubleshooting page. Tap the table, then tap in its top-left corner; three blue dots appear on the edges of the table when it’s selected. I have tapped the table, then tapped the icon in the top-left corner. I do not see three blue dots. I am not able to transpose my data.
560 2

1 reply

SGIII

Level 8

37,532 points

Oct 21, 2020 11:43 PM in response to A.D.STUDIO

To point to data in another table simply select a cell, type = to bring up the formula editor, and click the source cell in the other table. You can fill/copy paste the formula just as you can any other formula.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers Table Aliases

Welcome to Apple Support Community

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

Learn more Sign up