| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cell Displays 0
Now this should be easy. I have a workbook with 2 worksheets. Lets say when
A1 is filled in on worksheet 1 I want the same information to display in A1 on worksheet 2. I used a the formula on worksheet 2 in cell A1: =worksheet1!A1 why does that cell in worksheet 2 display a 0 when there is not yet information in the cell it's copying from in worksheet 1? How do I get it to just be blank until information is put into that A1 on worksheet1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Linked cell displays 0 | Excel Worksheet Functions | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Linked cell location of hyperlink | Excel Worksheet Functions | |||
Threaded Mode
