If a specific row contains a word, then clear specific content in corresponding column.

Hi,

First post on the forum, so let's see how it goes.

I have a row (will always be row 3) where each cell contains a day of the week, the days repeats for a year or so, making the row almost 400 cells.

Like this,
Mo - Tu - We - Th - Fr - Sa - Su - Mo - Tu - We - Th - Fr - Sa - Su - and so on...

Though, A3 doesn't have to be "Mo" because the days in this case can change (A3 can start with "Tu"), hence I think I need a macro.

So if this row contains a weekend, "Sa or "Su" I want all the cells in the column beneath that which contains a specific value to be cleared.

Example, if "Sa" or "Su" has 3 values in the columns under them, all the values that contain "X" or "Y" has to be cleared.

Like this:
Rows (1,2,3...,)
1----
2----
3 Mo - Tu - We - Th - Fr - Sa - Su - .. and so on..
4 A --- B --- X --- Y --- X --- B --- Y
5 A --- B --- X --- Y --- X --- X --- X
6 A --- B --- X --- Y - --X --- Y --- C

After the macro it should be:

1----
2----
3 Mo - Tu - We - Th - Fr - Sa - Su
4 A --- B --- X --- Y --- X --- B ---
5 A --- B --- X --- Y --- X --- ---
6 A --- B --- X --- Y - --X --- --- C


I would appreciate help on this.

Notice the two examples in the excel file.

Thanks in advance,
-Johan

The Morse Code is nice but it would make it a little easier to work with if you posted a sample workbook with some typical data.

Regards, TMS

This should work for you

Please Login or Register  to view this content.

Cheers
Diberlee

Just to build on the solution provided, which works with the sample provided:

Please Login or Register  to view this content.

This caters for any number of columns and rows.

Could probably be quicker using an array but I'll leave that enhancement for someone else


Regards, TMS

You're welcome. Thanks for the rep.