Keeping value the same across worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denise - 18 May 2008 20:38 GMT

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.

Reply to this Message

Nick Hodge - 18 May 2008 20:47 GMT

Denise

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

=TheName

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> I have a worksheet of master data. I want any information in A3 to always
> be
[quoted text clipped - 4 lines]
> Data'!$A4
> What am i doing wrong. I need to be able to insert names alphabetically.

Reply to this Message

GTVT06 - 18 May 2008 20:54 GMT

> 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)

Reply to this Message

Gord Dibben - 18 May 2008 21:12 GMT

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

Gord Dibben MS Excel MVP

>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.

Reply to this Message