LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
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 09:24 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04: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 10:43 PM


All times are GMT +1. The time now is 02:55 AM.

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"