Q: Retaining formula when row is deleted
I am using Numbers version 3.6.2 and El Capitan
I want to have a formula on one sheet (call it MARK) to access a cell (B2) on a different sheet call it CSV. This I can do.
I then want to print the sheet called Mark. This I can do.
The Problem
I now want to repeat the exercise but in order to get my next result I want to delete row 2 in CSV so that the new row 2 has the data I want in Mark. As soon as I delete the row in CSV I have an Invalid reference showing on MARK
I have tried with the spreadsheets in the cloud and local but I get the same result.
I have tried both of the references below.
CSV::B2
CSV::$B$2
Can somebody tell me what I am doing wrong or give me another way round the problem. I have looked at Automator and Applescript however they seem a little too complex for me.
Any help would be appreciated.
iMac (24-inch Mid 2007), OS X El Capitan (10.11.1), null
Posted on Oct 19, 2016 4:42 AM
In this case you should use the indirect formula...
change the formula from:
=CSV::'Table 1'::B2
To
=INDIRECT("CSV::'Table 1'::B2")
Posted on Oct 19, 2016 5:23 AM