Apple Event: May 7th at 7 am PT

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

How do I create a master numbers table with 8 columns that automatically pushes each of these columns individually to 8 separate numbers sheets.

How do I create a master numbers table with 8 columns that automatically pushes each of these columns individually to 8 separate numbers sheets.

Posted on Apr 19, 2020 10:27 AM

Reply
Question marked as Best reply

Posted on Apr 19, 2020 12:00 PM

Not possible.


But you can work in the other direction, and create an 8 column 'master' Table and 8 separate Tables, each of which automatically pulls data from one of the columns on the columns on the 'master. The receiving tables may be placed on the same sheet, or on separate sheets.


The 'formula' could be as simple as a cell reference to the 'master' table cell containing the data to be placed in the cell containing the formula.


Example:


The 'master' table is named "Master"


The second table is named "Sub 3"


Giving the tables names that are distinct within the document allows formulas to address those tables without needing to include the name of the Sheet on which the table is located. Note that with the formula used, the column labels in the header row and row labels in the header column are not required.


The formula shown on the second table is entered in cell A2 of Sub 3, then filled down the column to A10. Nubers automatically increments the number part of th cell reference as the formula is filled down the column.


Regards,

Barry

1 reply
Question marked as Best reply

Apr 19, 2020 12:00 PM in response to driverbob

Not possible.


But you can work in the other direction, and create an 8 column 'master' Table and 8 separate Tables, each of which automatically pulls data from one of the columns on the columns on the 'master. The receiving tables may be placed on the same sheet, or on separate sheets.


The 'formula' could be as simple as a cell reference to the 'master' table cell containing the data to be placed in the cell containing the formula.


Example:


The 'master' table is named "Master"


The second table is named "Sub 3"


Giving the tables names that are distinct within the document allows formulas to address those tables without needing to include the name of the Sheet on which the table is located. Note that with the formula used, the column labels in the header row and row labels in the header column are not required.


The formula shown on the second table is entered in cell A2 of Sub 3, then filled down the column to A10. Nubers automatically increments the number part of th cell reference as the formula is filled down the column.


Regards,

Barry

How do I create a master numbers table with 8 columns that automatically pushes each of these columns individually to 8 separate numbers sheets.

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