1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Auto hide rows based on formula results

Discussion in 'Business Applications' started by pandagurl, Mar 16, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. pandagurl

    pandagurl Thread Starter

    Joined:
    Mar 16, 2012
    Messages:
    9
    I have a sales report that shows number of leads by sales person and date. It's organized into a monthly calendar view (with dates running down instead of across) and I've used formulas so that I only need to change the year to autopopulate the dates to fall within the corresponding month. What I want to do is only show the actual business days in each month - so auto hide any Sunday or Saturday rows as well as the blank rows (just the rows that have formulas in column A, not the blank spacer rows) so that when I update for each year I don't have to manually hide the rows with no data. Can I do this with VBA code? I'm not sure if I've explained myself well, so please let me know if this doesn't make sense! I've attached my spreadsheet.

    For Windows XP, Excel 2010

    Thanks!
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,507
    First Name:
    Hans
    Hi, Try this one.

    If you enter 0 as year all rows are unihidden, enter a year value, weekend days are hidden.
     

    Attached Files:

  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,507
    First Name:
    Hans
    Forgot the blank ones, have to leave right now so I'll gect back to you
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,507
    First Name:
    Hans
    Got the blank rows too.
    I wonder if this is what you expected/ wanted.
     

    Attached Files:

  5. pandagurl

    pandagurl Thread Starter

    Joined:
    Mar 16, 2012
    Messages:
    9
    Yes, this is exactly what I wanted! Thanks so much!!!
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,507
    First Name:
    Hans
    You're welcome, don't forget to Click the "Mark Solved" button to close the post.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1045456

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice