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
Bookmarks