How to hide cells based on the result of another cell

[jerryisgood]

Here is my dilmma . . . I have a file with 23,500 rows and columns going all the way into "DC". What I am trying to accomplish is a code . . .

1. Looks at columns E, J, O, T, Y, . . . (Basically, 20 different columns that are each followed by four corresponding columns - So "E" would be an event and F-I would related to that event, followed by "J", which wouldb event 2 and so on . . .)

2. If any of those columns = a string of text "Action", I need to keep it. If they say anything else, I need to collapse the column and the four corresponding columns that follow it.

I know how to do this, but the tricky part for me is that I need it to go on a row by row basis. So basically, E2 might say "Action" and E3 may say "Action 3". In this case, I would need E2:I2 to remain intact. E3:I3 can either be hidden/collapsed or deleted

Does anyone have any ideas?
Thanks in advance.

[jerryisgood]

Another option would be to look at each of the event columns. If it's the event I'm looking for, then cope the event and it's corresponding cells to a new worksheet and then continue to do the same for each of the 20 events for each row. Can someone help me with the logic for this?

[jerryisgood]

http://excelexperts.com/if-value-equ...-row-new-sheet - Trying to adapt this perhaps.