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.

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

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.

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