Keeping value the same across worksheets

[Denise]

I have a worksheet of master data. I want any information in A3 to always be
in a different worksheet called phone directory. If I insert a row in master
data the cell in phone directory automatically changes to A4.
My formula is ='Master Data'!$A3. Inserting row changes to: ='Master
Data'!$A4
What am i doing wrong. I need to be able to insert names alphabetically.

 

[Nick Hodge]

Denise

Name the range (cell A3( via Insert>Name...Define) and then refer to that

=TheName



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[GTVT06]

I have a worksheet of master data.  I want any information in A3 to always be
in a different worksheet called phone directory.  If I insert a row in master
data the cell in phone directory automatically changes to A4.  
My formula is ='Master Data'!$A3.  Inserting row changes to:  ='Master
Data'!$A4
What am i doing wrong.  I need to be able to insert names alphabetically..  

Hello, Try this
=OFFSET('Master Data'!$A$1,2,0)

 

[Gord Dibben]

=INDIRECT("'Master Data'!" &"$A3")


Gord Dibben MS Excel MVP