sarao18592
New Member
- Joined
- Mar 4, 2021
- Messages
- 12
- Office Version
- 2019
- 2016
- Platform
- MacOS
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.
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.