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
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 |
#3
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 |
#4
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 |
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 |