VBA code to copy entire row IF a specific word is in a SPECIFIC column

    Quote from Haris1977

    Hmm..i see. I dunno why i keep getting these errors when i insert the macros. Maybe it is smth with my excel.


    1. Do not confuse Macros with Formulas ... In this particular case, you are dealing with Conditional Formatting ... so you are using Formulas ...


    2. What is smth ...???


    3. Will add the Formula to your latest test file ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    1. Yes, you are right. I know Conditional Formatting is different than Macro's. I was using conditional formatting to enter your "formula" but i am getting error.
    2. Smth = something (abbreviation)
    3. Thanks again!

    Thanks for your Thanks AND for the Like :smile:


    P.S. J9 cell will turn red on Friday

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    You are welcome :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login