Copy range after specific criteria is found

[Tapyr]

Hi,

I would like kindly ask you with my request and help me to write some macro which can cover it. Maybe it will be quite harder for me to explain it, but I try my best.

I got some converted data from .pdf in excel (Sheet: "Case") and now I am trying to merge some important data together in 2nd sheet (Sheet: "Result").

There are 2 tasks which need to be done.

TASK 1:
Step1: I need to find the first "key word" which is "Account"
Step2: Copy names from column 'B' (highlighted by yellow) if there is a Actor condition in specific range (range = rows under "Account" up to first blank row. In my example, up to row 18)
Step3: Paste it to sheet "Result" in cell 'C2'

TASK 2:
Step1: I need to find second "key word" which is "BATMAN"
Step2: Copy list of masks from column 'E' (highlighted by yellow), where beginning of range is 2 rows under BATMAN and ended by last filled row in column "D" =
Step3: Paste it to sheet "Result" after the last filled row in column 'C'

I believe that attached example file where you can find highlighted cells in example sheets make more sense for you than my wording above :-).

Thank you in advance

[sintek]

One way...

Please Login or Register  to view this content.

[Tapyr]

Hi sintek,

it looks amazing. I've tested it on my example, also tried to add some additional fields and it always showing what I wanted. Also code is in very user-friendly form, so I should be able to modify it for real project.
I have no more words, just you are THE BOSS ;-).

Thank you, I am going to close this thread as solved and of course send some reputation points for you.

Once again THANK YOU VERY MUCH

[sintek]

.........................
Thanks.png