I have an Excel Worksheet that has two tabs: WorkList & WorkHistory. WorkHistory logs productivity or work completed by an employee. Specific data is collected while some are populated from the WorkList, others like Date Worked & Time Worked are generated by the system. I have attached the Excel Document that I have completed but am having problems with the VBA code that is attached to the WorkList sheet. The VBA code currently logs the "Status", "Comment", "Plan_Mneum", "Date_Worked", "Time_Worked", "Collector" and "Comment" if the user enters data on columns B, C, or D of the WorkList Sheet. The problem is that a seperate entry is created for each data change. I need for all changes to be logged in 1 entry in the WorkHistory until the user changes rows. Also, if the user comes back and changes data to a row already worked, all data is recorded as seperate entry in the WorkHistory. I have attached the Excel Document. Thanks.
Start Free Trial
