| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to cell shows 0 value
I have a workbook that is used for vacation time. I have a sheet for each month and on each of these sheets in column A is linked to the main sheet where employee names are entered. If a name is entered then it gets carried to all the other sheets, if there is no name entered, the following sheets show a zero for the data entered. Is there a way so that I can not have the zero showing on the sheets and still have the link? Thank You -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=563331 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link to cell shows 0 value
=if(sheet1!a2="","",name)
hth regards from Brazil Marcelo "tanyhart" escreveu: I have a workbook that is used for vacation time. I have a sheet for each month and on each of these sheets in column A is linked to the main sheet where employee names are entered. If a name is entered then it gets carried to all the other sheets, if there is no name entered, the following sheets show a zero for the data entered. Is there a way so that I can not have the zero showing on the sheets and still have the link? Thank You -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=563331 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link to cell shows 0 value
One option is use conditional formating, in the format menu, and create a
condition to use white ink if the value of the cell is 0 Hope this helps, Miguel. "tanyhart" wrote: I have a workbook that is used for vacation time. I have a sheet for each month and on each of these sheets in column A is linked to the main sheet where employee names are entered. If a name is entered then it gets carried to all the other sheets, if there is no name entered, the following sheets show a zero for the data entered. Is there a way so that I can not have the zero showing on the sheets and still have the link? Thank You -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=563331 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link to cell shows 0 value
Figured it out Tools Options take checkmark out of 'Zero Values' So simple, yet annoying -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=563331 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using date, link to a cell | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| Use Cell Content to Build Link | Excel Worksheet Functions | |||
Hybrid Mode
