I would like to repeat a desk from one sheet to a different however conserving the native reference. The situation is like this:
Sheet1
Table1
| Merchandise | Value |
|---|---|
| it_1 | 10.00 |
| it_2 | 15.00 |
| … | … |
Table2
| Abstract |
|---|
| =SUM(Table1::Value) |
Sheet2
Table1
| Merchandise | Value |
|---|---|
| it_3 | 20.50 |
| it_4 | 17.30 |
| … | … |
And I wish to copy Sheet1::Table2 into Sheet2 transferring the components references, however after I hit Cmd+C/Cmd+V the desk is copied like:
Sheet2::Table2
| Abstract |
|---|
| =SUM(Sheet1::Table1::Value) |
Is there a approach to copy the desk so the components retains being SUM(Table1::Value) as an alternative of being copied conserving the reference to the unique cells?
Please let me know if there’s something not clear in my query. Thanks upfront in your feedback/solutions.
