With some help from a few users in this forum I created the attached spreadsheet for job planning at work. When a machine is assigned in column A on the Master List worksheet one of the macros is suppose to copy the data from that row and then paste it to the worksheet with the corresponding name. If the machine is then changed on the master list to a different machine or "completed" the macro is suppose to copy the row of information to the new worksheet with the corresponding name and delete it from the previous worksheet. We have been using the spreadsheet for about a month and it was working fine until the past week or so. Now the macro only works some of the time. A lot of the time when the machine is changed on the Master List the data will be copied to the new worksheet but will also be left on the original worksheet. Occasionally the machine can be assigned or changed on the Master List and the data does not copy to the corresponding worksheet at all. I have very limited knowledge of VBA so I am not sure what would be causing the loss of functionality. I would really appreciate any help that anyone could provide!
Bookmarks