How Do I Avoid #REF! In Formulas?
On 2/7/2013 at 2:07:57 AM Kevin@Radstock wrote:
Hi tb
May be the INDIRECT & ADDRESS functions:
=INDIRECT(ADDRESS(ROW(A15),1,4,1,"Sheet1"))
tb;1609161 Wrote:
I am using Microsoft Excel 2007.
My spreadsheet has two tabs, Sheet1 and Sheet2.
In Sheet2 I have the following formula going down Col. A linking to
data on Sheet1:
='Sheet1'!A15
='Sheet1'!A16
etc. etc.
But if I delete some rows on Sheet1, then the formula on Sheet2
becomes:
='Sheet1'!#REF!
What do I need to do so that the dreaded #REF! does not happen when
I delete rown on Sheet1?
--
tb
It seems to be working. Thanks, Kevin.
--
tb
|