Try the attached version. The error when deleting or copying rows should now be fixed. The macro works in the following manner:
In the APPLICATION sheet:
- If you add any new status, the new sheet will be created and the row of data will be copied to it.
- If you change any existing status to a name that does not have an existing corresponding sheet, the new sheet will be created and the row of data will be moved to the new sheet.
- If you change any existing status to a name that has an existing corresponding sheet, the row of data will be moved to the existing corresponding sheet.
Bookmarks