Hi All,
My problem is If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet
I have a summary page when dates staff have completed courses are displayed in cells D4 to K4 i have set up a macro that once all dates are in in cell N4 value of "Completed" is there.
I wish to copy the cells with dates D4:K4 (Values) to employees own sheet and have the dates placed in a column D5:D20.

First of all can this be done :P

If anyone can help with code this would be great.

Thanks in Advance