vba code to update data as per criteria

Example.xlsxHi,

i am trying for vba code for below criteria,

1. in sheet1 i am filtering for column D for dates i want and copy mail id of column H
2. goto sheet 2 and find that mail id in column D, now according to the column C in sheet1 confirmed and cancelled i would like to enter the registration as yes if confirmed
    and for cancelled as cancelled in sheet2
3.update the offering date(column F-sheet2) as event start date(column B-sheet1) for yes
4.update comments only for cancelled as "Cancelled on 10/04/2018(column E date-sheet1) from the 16/04/2018(column B-sheet1) offering"

Please suggest.

Thank you in advance.