Will a Macro do this? If so, HOW?
 

I have a tracking spreadsheet going right now. Lots of dates and names.
I would like to set up this sheet so that if I change a status (via dropdown
menu) to complete, it automatically changes all dates to the next calendar
year and clears that 'status'.
Is this possible? Do I need a macro? And how do I set it up? I've never
coded a macro, just recorded them...