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.

How do I move a table from one sheet to another?

How do I move a table from one sheet to another? ... 'nough said ... it should be simple I know but the the numbers help system (sic) is just telling me to drag a circle.


Copy and Paste is not an option ... the tables to be moved are referenced by other tables.


Thanks.

Posted on Jun 18, 2020 2:37 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 18, 2020 6:08 AM

Hi Folbo,


Folbo wrote:
Copy and Paste is not an option ... the tables to be moved are referenced by other tables.

Try Cut and Paste. Here is a table named "Data" that is referenced by Table 2.

You do not say what formulas you are using, so I am using SUMIF as an example.

The formulas in Table 2 reference the Data table.

Formula in B2 of Table 2 (and filled down) =SUMIF(Data::A,$A2,Data::B)



Click on the "Data" table, click on the "bullseye" top left and Menu > Edit > Cut (command X).

Insert a new Sheet and delete the default table.

Paste.

Here is Sheet 2



Here is Sheet 1



The formulas automatically adjust.

Please call back with questions.


Regards,

Ian.

5 replies
Question marked as Top-ranking reply

Jun 18, 2020 6:08 AM in response to Folbo

Hi Folbo,


Folbo wrote:
Copy and Paste is not an option ... the tables to be moved are referenced by other tables.

Try Cut and Paste. Here is a table named "Data" that is referenced by Table 2.

You do not say what formulas you are using, so I am using SUMIF as an example.

The formulas in Table 2 reference the Data table.

Formula in B2 of Table 2 (and filled down) =SUMIF(Data::A,$A2,Data::B)



Click on the "Data" table, click on the "bullseye" top left and Menu > Edit > Cut (command X).

Insert a new Sheet and delete the default table.

Paste.

Here is Sheet 2



Here is Sheet 1



The formulas automatically adjust.

Please call back with questions.


Regards,

Ian.

Jun 18, 2020 2:55 AM in response to Folbo

I don't think it's going to be possible. It would be a good idea to suggest this as a feature as it does make sense that somebody might want to move a table while maintaining references to its cells. I looked to see if it's possible to do a find and replace to change the cell references, and that doesn't seem to be possible. You'd need to copy the table to the other sheet and then manually adjust the formulas to reference to the new table.


You can send feedback at https://www.apple.com/feedback/numbers.html

How do I move a table from one sheet to another?

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