VBA Search for condition, copy and paste array

[JohnKiernan]

Hello Everyone!

Forgive me in advance I am new to the forum and do not have much experience with VBA (I am trying to learn).

Currently, I perform a manual task here I have created two additional columns at the end of a set of data. The first column signals the beginning and end of a series (“”, “Begin”, or “End”). The second column checks to see if a condition is met within that series and shows as either “Alert” or “”. I would like to remove the individual rows (from “Begin” to “End”) where the condition is met in column 4 (“Alert”) and move them to a new sheet in the workbook. There can be multiple instances of “Alert” in column 4, and I would like to return only those sequences where there is an “Alert” in that column. That is to say if there is a series of rows (Begin to End) that do not have an Alert in column four I would not wish to see them.

Can someone please point me in the right direction with this?

I have included an attached example

Thank you in advance!

Best,

Jack

Jack_Question.xlsx

[rylo]

Hi

Try this. It doesn't have any formatting, but I think it does bring across the relevant data.

Please Login or Register  to view this content.

rylo

[JohnKiernan]

This works great! Thank you very much!