Hi Rylo
i'm having some problems with the code you did for me.

When i run the code at work on windows97 i'm getting and error and the Dates in the master rota that it matches are deleted. it does however copy all the times to the correct cells.

you also said that if the dates in the master rota were numeric, then it wouldn't be too hard to enhance the code to do the conversion before processing.

The format of the date cells in master are set as general.

Can you still help please

Dave