Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,047
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 95
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using date, link to a cell Weasel Excel Discussion (Misc queries) 4 March 21st 06 08:44 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 02:36 AM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Cell only shows link in text, not contents of reference cell Jay Mac New Users to Excel 4 August 23rd 05 08:36 PM
Use Cell Content to Build Link flattire00101 Excel Worksheet Functions 1 June 17th 05 05:40 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"