mattmalan6
New Member
- Joined
- Dec 20, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a "Task" tab that has a priority and status for each task. I want to delete the task from "Tasks" and add a row to "Completed Tasks" when the status of that task changes to completed. I've been playing around with Macro and the on edit feature. But it's a little complicated for me because both my tables of data are on different rows and columns. So it's not lining up very well. I'll post my spreadsheet to help give you guys a better idea of what I'm talking about.
Google Spreadsheet: Tasks
Google Spreadsheet: Tasks