how do i link merged cells to a merged cell in another worksheet.

[Guest]

I have a work flow spreadsheet that has several worksheets on it. As each
department adds info I want certain cells to be automatically filled on the
next sheet. So the value of merged cells B1:E1 on worksheet Department 1
will be displayed on the second worksheet in merged cells F2:H3.

Is it possible. If I enter the "=" and point to department 1 ws I get the
text "=B1:E1" as if it isn't a formula.

Thanks in advance for your help.

 

[Max]

.. value of merged cells B1:E1 on worksheet Department 1

displayed on the second worksheet in merged cells F2:H3.

Think merging cells "reduces" it
to just the top left cell within the merged range, eg:

merged cells B1:E1 == B1
merged cells F2:H3 == F2

(the "==" means "equivalent to")

So in the 2nd sheet,
use in merged cells F2:H3 : ='Department 1'!B1
should do it for you

Above said and done,
it's usually better to avoid using merged cells
to avert downstream difficulties

---

 

[Guest]

thanks this works but something I don't understand is that both merged cells
are text fields but if my first cell has nothing in it... the linked one
shows a zero? Any ideas?

 

[Guest]

thanks this works but something I don't understand is that both merged cells
are text fields but if my first cell has nothing in it... the linked one
shows a zero? Any ideas?

That's the way Excel evaluates link formulas pointing to empty cells <g>

But we can mask it to appear as "empty" by using an IF, eg:
=IF('Department 1'!B1="","",'Department 1'!B1)

instead of just: ='Department 1'!B1

---