I have two similar worksheets within the same workbook. One sheet is sorted
by name and the other sheet is sorted by a date for a speicfic name. Is
there a way to change the date on the sheet, sorted by name, and that will
automatically find the name on the other sheet(sorted by date) and change the
date to the second sheet?