how to create a link between 2 cells in different spreadsheets?
when using numbers on MacBook Pro/IOS X - how to create a link between 2 cells in different spreadsheets?
iPhone 4, iOS 4.3.3
when using numbers on MacBook Pro/IOS X - how to create a link between 2 cells in different spreadsheets?
iPhone 4, iOS 4.3.3
Hi Ujkl,
If you mean linking between two Numbers documents, that can't be done except by using an AppleScript.
If you mean linking between two Sheets (Tabs) in one document, that can be done. Point and click to create a formula.
Regards,
Ian.
Thanks but seems i should have been more specific. i need that the result of a formula or a date on a certain spreadsheet will appear also on other sheets in the same file (not on the same cell position). when data is changed in the first cell result will change on the other ones. like 'paste and link' in Excel.
In the cell where you want the duplicate data to appear from another sheet/table do the following:
type the equal sign ("=") then click the cell you in the sheet table while contents you want to appear in the cell where you just typed the equal sign"
it reads "The cell I click equals the result of the formula or the contents of the next cell I click"
Thanks!
Mike
how to create a link between 2 cells in different spreadsheets?