| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting cells from two pages
I am trying to link cells from a master page to individual pages, however
whenever I do this, the number 0 shows up on the individual page. Here is an example of the code I tried: =master!B4 Any suggestions or help would be appreciated! -- marketing123 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Connecting cells from two pages
=master!B4
Try instead: =IF(master!B4="","",master!B4) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "marketing123" wrote: I am trying to link cells from a master page to individual pages, however whenever I do this, the number 0 shows up on the individual page. Here is an example of the code I tried: =master!B4 Any suggestions or help would be appreciated! -- marketing123 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Connecting cells from two pages
Your formula looks fine. What is the value in B4 on the "master" worksheet?
Also, check the cell formatting where your formula is. Regards, Paul -- "marketing123" wrote in message ... I am trying to link cells from a master page to individual pages, however whenever I do this, the number 0 shows up on the individual page. Here is an example of the code I tried: =master!B4 Any suggestions or help would be appreciated! -- marketing123 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connecting to specific cells in Excel | Excel Discussion (Misc queries) | |||
| connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
| Connecting data in different pages and make calculations | Excel Worksheet Functions | |||
| Referencing cells on other pages | Excel Worksheet Functions | |||
| How I can combine cells of different pages? | Excel Discussion (Misc queries) | |||
Linear Mode
