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.