I currently have a worksheet which is being used as a monitoring form. On this form there is a milestone which requires the subject to enter a completion date or a revised date for completion (3 columns in Total).

What I would like to be able to do is copy any row(s) that have a figure entered into revised date column into sheet 2 of the workbook.

That way I should have a worksheet (sheet 2) That would have a list that contained all the milestones with revised dates.

What I am looking for is any advice on the best way to go about this? I was thinking about using code to do this (possibly implemented by a command button). Although my knowlege of code is quite limited.

Many Thanks

JP