toomanydogs
New Member
- Joined
- Dec 21, 2024
- Messages
- 2
- Office Version
- 365
- 2024
- Platform
- Windows
Hello,
I need help to create a code that when you hit the button it to checks to see if the status of a project in the sheet "Inbox" is marked completed (column K). If it is completed, then it needs to move to another sheet based on the location (column A) and delete the entire row. So if a project is completed in Location 1, then it needs to move to another excel sheet labeled Location 1. If a project is marked as completed for Location 2, then it needs to move to another excel sheet labeled Location 2. If the status bar is empty or in progress it needs to be left behind.
The projects start in row 3 of the sheet.
Thank you!
I need help to create a code that when you hit the button it to checks to see if the status of a project in the sheet "Inbox" is marked completed (column K). If it is completed, then it needs to move to another sheet based on the location (column A) and delete the entire row. So if a project is completed in Location 1, then it needs to move to another excel sheet labeled Location 1. If a project is marked as completed for Location 2, then it needs to move to another excel sheet labeled Location 2. If the status bar is empty or in progress it needs to be left behind.
The projects start in row 3 of the sheet.
Thank you!