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?
"Max" wrote:
.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ibbm" wrote in message
...
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.