Good day, I am new to VBA. I need help to copy cells, column B and C from one sheet to another sheet if criteria in column D is YES. Basically it means that on the name list of May 2021 if I have seen said person I mark column D next to each name with “YES” and then their registration number and surname & initials must be automatically copied to sheet “NOV 2021” (6 months onwards) in the workbook. Same will apply in the sheet “JUNE 2021” onwards
If sheet “MAY 2021” column “D” (different rows) are “yes” the data in column B and C, rows 2 and downwards must copy automatically to sheet “NOV 2021” (6 sheet onwards) in the first open rows in column B and C.
It would be highly appreciated if someone can assist in this regard.
If sheet “MAY 2021” column “D” (different rows) are “yes” the data in column B and C, rows 2 and downwards must copy automatically to sheet “NOV 2021” (6 sheet onwards) in the first open rows in column B and C.
It would be highly appreciated if someone can assist in this regard.