Filter Data based on a set of values

[klturi421]

I have been utilizing an array formula for a while to filter out specific data that I am looking for, however, those arrays are causing some delays due to the amount of calculation that is going into each one. Yes I know that I can use a formula to get the job done but for simplicities sake i'd rather be able to run a macro that can check the fluctuating list and be able to output that same data without having to drag down a bunch of arrays that may not even run.

As you will see in the spreadsheet, there are a set of 4 columns, I want the second set of data (to the right) to have only data that is for "ACD" AFTER "RING", which I have included in an example above where the output should be.

Book2.xlsm

[HSV]

Hello,

Would this do the trick?

Please Login or Register  to view this content.

[YasserKhalil]

Mr. HSV what number 7 at the end of this line?

Please Login or Register  to view this content.

[HSV]

It stands for

Please Login or Register  to view this content.

[skywriter]

Try this.

[klturi421]

Hello,

Would this do the trick?

Please Login or Register  to view this content.

That almost does the trick. While it does copy each RING and ACD event I'm wanting it to only pull the first ACD after each RING but does not need to include each one. Much more like the example that I posted.

[HSV]

Okay, that I have missed.
Without copy something faster.

Please Login or Register  to view this content.

[klturi421]

Okay, that I have missed.
Without copy something faster.

Please Login or Register  to view this content.

Works like a charm! Thanks for that!

[skywriter]

Works like a charm! Thanks for that!

It looks like my solution in post #5 did what you asked, but you seemed to have ignored it. Of course I guess I should get partial credit since the person who wrote the solution you chose took the name of my sub procedure and used it instead of making up their own.

[klturi421]

It looks like my solution in post #5 did what you asked, but you seemed to have ignored it. Of course I guess I should get partial credit since the person who wrote the solution you chose took the name of my sub procedure and used it instead of making up their own.

I honestly did not see your reply. Not due to looking past it but by the time I updated my post you posted yours and I didn't see it until after HSV already made a change to the VB. I do appreciate everyone's input. I will likely make use of both of them to be honest.