I am trying to create a macro to track date changes made to the schedule. I created a separate worksheet to track the original date, new date and a timestamp to a tracking worksheet using the Worksheet_Change function I am able to handle individual changes but need help if multiple values are pasted into the column. What is the most effective way to loop through multiple values being pasted into the due date column?
Bookmarks