I am trying to figure out a way to perform a cell match. The worksheet "Control" is the control document. The worksheet "Dump" is the daily dump. I need to confirm matches between the two worksheets. If a value is in the "Dump" sheet but not in the "Control" sheet. The value should be appended, and an added date should be populated (Today's Date). If a value is in the control sheet but not in the "Dump" sheet. The cell should be marked as deleted in the date deleted column.
Attached is an example worksheet.