I need to copy single row values from columns A, F and R on worksheet "RD activity review log" when column P has a value of "On hold" and the column R date value is changed. I need the values from these three cells to be pasted onto the next empty row of worksheet "Paused Log" after each time the criteria is met.
I have the following code as a worksheet change event, but would like to change it so that I only copy the values from columns A, F and R rather than the values from the entire row. Can anyone help please?
Bookmarks