Find all matches in workbook and offset the results into another sheet (VBA)

[sarao18592]

Hi everyone,
I'd like some help if possible!
I currently have a workbook with 4 sheets(the number of sheets will change) and one more sheet called Results.

I would like to look for the string: "Employee Code:-" in Column B, and get the value in Column S and Column K and paste it in Results A and B respectively. (Moving to the next find if Column S and Column K have the same value)

I would then like to copy a range of values below where Employee Code is found. 3 and 4 rows below and from Column C to Column AM. Copying this into Result Column C.
Then leaving a line after the results have been pasted and repeating for the rest of the find values.

E.g. if Employee code is found in B17, I would like the value of S17 in Result(A4) and K17 in result(B4) if S17.value <> K17.value. Furthermore, C20:AM21 in Result(C4:AM5).

Then when the next employee code is found, the result is pasted in Row 7.

 

[Fluff]

Duplicate to: Find all and get offset value in new sheet(code error)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.