I have a call log file that has 2 worksheet Open and Closed, Under the Column Status(G column) when I put closed I would like the entire row to be moved to the Closed Worksheet. Here are the columns I have. This will be constantly added to so the range will keep growing.
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Date | Name of Person/Company | Phone # | Reason of Call | Employee's Task | Follow up Needed | Task Complete |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>