OO Calc: link to sheet
Hi,
i am looking all over but cannot find this... How can i link (point to, reference, etc) from one Sheet to another? I've found a "DDE" function, but it doesn't work. Is there something like "Sheet3.A1"? Thanks |
On a different tab in the same spreadsheet? (It may work on different spreadsheets, but I haven't tried it.) Same way as you would on the same tab of the spreadsheet (well, one of the same ways that you could...).
In the destination cell, enter '=', navigate over to the source cell and click to select that cell. Done. (Unless you want to apply a formula to that value...that's obvious too, but I always check that I'm getting what I expected before I complicate things further, but the 'cell colouring/debug functions don't really help that much when you can't see both cells at once, obviously.) |
All times are GMT -5. The time now is 06:58 PM. |