+ Reply to Thread
Results 1 to 6 of 6

Hide Values Until Additional Values Are Entered

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Hide Values Until Additional Values Are Entered

    Hey yall. I have a problem that has plagued me for a year now and I haven't been able to find a solution. In my Excel sheet, I want the "Days off" values hidden until a value is put in for "Days Worked". (That part sounds simple) What I can't figure out is how to get a sum of the "Days Off" count, without including the days in future months. What I mean is, right now my sheet shows that I've been off 274 days this year. Obviously this is not correct.

    Hopefully I explained this well enough and yall can give me a hand.

    Thanks,

    Days Worked.xlsx
    Last edited by DrillinHole; 07-14-2015 at 02:19 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,193

    Re: Hide Values Until Additional Values Are Entered

    Attach a Workbook
    (please do not post pictures or links to worksheets)
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-09-2014
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Hide Values Until Additional Values Are Entered

    I have revised my post. Sorry about that bud and thanks for looking into it.

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Hide Values Until Additional Values Are Entered

    Hi DrillonHole

    In cell G14 Formula etc., etc.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    01-09-2014
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Hide Values Until Additional Values Are Entered

    Quote Originally Posted by jaslake View Post
    Hi DrillonHole

    In cell G14 Formula etc., etc.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    John, you are a life saver!!! Thank you so much for the quick reply. My accountant will love you too lol.

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Hide Values Until Additional Values Are Entered

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting numeric values when several values are entered in a cell
    By Tryin2Excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2015, 02:30 PM
  2. [SOLVED] Sum of values based on values in different column with additional criteria
    By jimmyb555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2015, 02:31 PM
  3. I need to enter the values in next row if values are entered in row.
    By kk59527 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 06:14 AM
  4. Replies: 1
    Last Post: 02-06-2014, 03:00 PM
  5. [SOLVED] Different background color for entered values then values from formula
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2011, 07:50 AM
  6. If query additional values
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2007, 10:13 AM
  7. userform won't use entered values, hide, or cancel properly
    By fern in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 07:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1