Hey y'all. I've been scouring the internet to piece together codes that would be able to accomplish the task at hand.
I currently have a worksheet that has the names of clients (a), when their next meeting is (b), and was the meeting completed? (c).
I'm trying to make it so, once a meeting has been completed and the worker puts in the txt "Yes" a new row appears beneath the client, copying down the client name and adding 84 days the the cell above (in B). I've already tested a code that then moves the completed meeting to a new sheet.
<tbody>
</tbody>
I currently have a worksheet that has the names of clients (a), when their next meeting is (b), and was the meeting completed? (c).
I'm trying to make it so, once a meeting has been completed and the worker puts in the txt "Yes" a new row appears beneath the client, copying down the client name and adding 84 days the the cell above (in B). I've already tested a code that then moves the completed meeting to a new sheet.
Name | Current Meeting Date | Completed? |
John Smith | 7/25/2018 | |
Morgan Freeman | 8/1/2018 |
<tbody>
</tbody>