Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ibbm
 
Posts: n/a
Default how do i link merged cells to a merged cell in another worksheet.

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default how do i link merged cells to a merged cell in another worksheet.

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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ibbm
 
Posts: n/a
Default how do i link merged cells to a merged cell in another workshe

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.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default how do i link merged cells to a merged cell in another workshe

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy single cell into cell that is merged from two cells? Rod Excel Discussion (Misc queries) 3 January 22nd 06 10:24 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Why can't I link a cell from worksheet to another when it has an . FV Excel Worksheet Functions 0 April 7th 05 06:33 PM
How do I link the worksheet tab to a cell in the worksheet? Husker87 Excel Worksheet Functions 2 March 3rd 05 11:43 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"