Reporting Macro (viewing columns, reporting in another)

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

Try such code:

Please Login or Register  to view this content.

If it is not fast enough (I expect it colud slow down if if there is many open/closed changes in a column), the output could be stored temporarily in the array and then written into the sheet in one action.

Kaper,

Thank you! This seems to work very well. I appreciate the assistance.

Jason,

Glad to hear that, and thanks for marking thread solved and for Rep+