Group,

I would like some assistance to create a macro to perform the following actions:

1. View columns B, C, D for the first and last "Open" indication series
2. Report the first and last indications in columns: F & G, H & I, J & K respectively
3. (If possible) separate each series with empty cell

In the attached, I have manually entered a few of these for an example of the end goal I would prefer.

**Be advised, I had to delete many rows of text to reduce the file size to upload. My actual work book has 40K plus rows of data...

Any help will be appreciated.

Outage Check Values Test.xlsx