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:39 AM

Reply
4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Retaining formula when row is deleted

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.