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

[ibbm]

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ibbm" <ibbm@discussions.microsoft.com> wrote in message
news:89748C0B-194F-414D-89F6-FC32A3728AE7@microsoft.com...
> 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]

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" <ibbm@discussions.microsoft.com> wrote in message
> news:89748C0B-194F-414D-89F6-FC32A3728AE7@microsoft.com...
> > 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]

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