Find a text string in a column and perform action if true

  • I have a column that contains a text string (ex: NOTE 5). I want to search this column to see if there is a string other than "NOTE 5" (ex: NOTE 6). If there is I print notes 1-6, if not I print notes 1-5. IF "NOTE 6" is in column o (o7:o100) THAN print notes 1-6 ELSE print notes 1-5.

  • Re: Find a text string in a column and perform action if true


    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Find a text string in a column and perform action if true


    To be honest, my VB isn't very good. This looks great but how do I put this in as Excel file?

Participate now!

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