Home » Forums » Open Source Learning Center » Question and Answer

Retaining cell reference

Submitted by YoungDave 1957 on 3 July, 2013 - 05:26

Hi
I want to display the text from cells in sheet 'Occupation data' in another sheet

I am using this formula =+'Occupation data'!A2 which works OK

However, when I delete row 2 in the 'Occupation data' sheet, the new data in Occupation data'!A2 is not displayed and the formula shows =+'Occupation data'!#REF!

Is there a method/formula that will retain the reference to Occupation data'!A2 after rows are deleted or added
Cheers

‹ How to create an excel that change of drop down then the multiple lists will change automatically? populate data automatically from sheet to another ›
»

One simple thing which you

Submitted by saurabhlakhanpal on 3 July, 2013 - 10:23.

One simple thing which you can do is copying the cell contents and then paste values.

»