Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to copy a range from one tab to another in Calc while preserving the links to the first tab

I've created a spreadsheet, and while creating it I kept it all in one tab for ease of use.

I now need to make it easier to read so I'm separating out sections into different tabs. The spreadsheet is a financial model so in this case the original tab had assumptions, income statement, balance sheet and cashflow all on the one big sheet. I'd now like to put the income statement, balance sheet and cashflow statements on separate tabs, but I'd like to preserve the link in the formulas to the assumptions in the first tab.

When I try and just cut and paste, the numbers look like they have copied successfully but the formulas refer to the destination sheet. Any modification causes errors all across the sheet. I can link to the original cells and hide those rows but that doesn't seem very efficient. A cut and paste-link fails with errors.

Any thoughts on how I can do this? Thanks

How to copy a range from one tab to another in Calc while preserving the links to the first tab

I've created a spreadsheet, and while creating it I kept it all in one tab for ease of use.

I now need to make it easier to read so I'm separating out sections into different tabs.

The spreadsheet is a financial model so in this case the original tab had assumptions, income statement, balance sheet and cashflow all on the one big sheet. I'd now like to put the income statement, balance sheet and cashflow statements on separate tabs, but I'd like to preserve the link in the formulas to the assumptions in the first tab.

When I try and just cut and paste, the numbers look like they have copied successfully but the formulas refer to the destination sheet. Any modification causes errors all across the sheet. I can link to the original cells and hide those rows but that doesn't seem very efficient. A cut and paste-link fails with errors.

Any thoughts on how I can do this? Thanks