| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
| How do I link the worksheet tab to a cell in the worksheet? | Excel Worksheet Functions | |||
Threaded Mode
