| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
linking worksheets
I'm trying to link two worksheets and I know how to link cells between sheets
but if I try to link blank cells the destination cells have zeros, how do I get rid of zeros without losing the links. This seems to be a 2000, 2002, and 2003 problem. Help Please. Thanks. |
|
#2
|
|||
|
|||
|
Hi Jeff
ToolsOptions..View Zero values -- Regards Ron de Bruin http://www.rondebruin.nl "Jeff" wrote in message ... I'm trying to link two worksheets and I know how to link cells between sheets but if I try to link blank cells the destination cells have zeros, how do I get rid of zeros without losing the links. This seems to be a 2000, 2002, and 2003 problem. Help Please. Thanks. |
|
#3
|
|||
|
|||
|
I like:
=if(sheet2!a1="","",sheet2!a1) Then cells that are really 0 come through ok. Jeff wrote: I'm trying to link two worksheets and I know how to link cells between sheets but if I try to link blank cells the destination cells have zeros, how do I get rid of zeros without losing the links. This seems to be a 2000, 2002, and 2003 problem. Help Please. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
| linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
| Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
| Simplify Linking to several worksheets?? | Excel Worksheet Functions | |||
| Linking Data between worksheets in a workbook | Excel Worksheet Functions | |||
Linear Mode
