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

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.

https://stackoverflow.com/questions/66775037/find-all-matches-in-workbook-and-offset-the-results-into-another-sheet-vba March 24, 2021 at 01:02PM