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: Macro for excel 2007 to hide rows based on any data entered in a column

Discussion in 'Business Applications' started by criticaleye777, Nov 16, 2012.

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

    criticaleye777 Thread Starter

    Joined:
    Nov 16, 2012
    Messages:
    2
    I am trying to hide rows of my worksheet that show a date in the completed column.
    The orders that are complete have a date in column F up to this point I highlight them green so I know they are completed but it would be nice if they highlighted green and were hidden when a date was entered into the completed column.
    Can someone assist me with creating a macro that will do this?
    I am very new to macros so please forgive my lack of knowledge.

    I have attached a sample of what I am doing however inf has been changed.

    I am using Excel 2007

    Thank you,
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Hi, welcome to the forum,

    I put some simple code in the Sheet's vba

    Make sure you allow macro's to be run

    Just enter a date in the last row of column F for testing.

    For the other green rows, just click in column F and update the date by retyping it
     

    Attached Files:

  3. criticaleye777

    criticaleye777 Thread Starter

    Joined:
    Nov 16, 2012
    Messages:
    2
    Thank you very much for your help Hans!
    I sure wish I understood how you did that!
    Thanks again!
    :)

    Criticaleye
    Tommy
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    You're welcome
    Just take a look at the sheet's vba, it's all there.
     
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/1076999

  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