From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla

hi
the best idea i can give you is not to use merged cells.

Regards
FSt1

"OrlaLynch" wrote:

From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla

If I don't though my only option from what I know is to use 'Center Across
Selection' setting but that does not work for what I want so I will still
need to use merged cells. Is there any other option for me?

Thanks anyway,
Orla

"FSt1" wrote:

hi
the best idea i can give you is not to use merged cells.

Regards
FSt1

"OrlaLynch" wrote:

From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla

Well, you could try to explain in a bit more detail what it is you are
trying to achieve and what you have tried so far, then someone might
be able to suggest an alternative way of doing it.

Pete

On Aug 15, 6:54*pm, OrlaLynch
wrote:
If I don't though my only option from what I know is to use 'Center Across
Selection' setting but that does not work for what I want so I will still
need to use merged cells. Is there any other option for me?

Thanks anyway,
Orla



"FSt1" wrote:
hi
the best idea i can give you is not to use merged cells.

Regards
FSt1

"OrlaLynch" wrote:

From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla- Hide quoted text -

- Show quoted text -