Hello,
I'm trying to make a shift log more user friendly. If I write a job up in sheet "log" and choose "priority" from the drop down menu in column E, I would like to copy that row columns B,C,D into the next available row +1 in sheet "Priority Work". I should also like this to delete if I go back to the log and select "complete" from the drop down list.
Similarly, I would like the same to happen for sheet "Follow Up" if "follow up" is selected from the dropdown.
I've tried pasting numerous bits of VBA of this forum and trying to alter them and failed miserably and I'm pulling out what little hair I have left.
Many thanks in anticipation
Andy
Bookmarks