Filtering data

Thanks for your response. Sorry to be so long replying.

The only difference I can see is that my data is in columns D and H whereas you have a solid block of data.

Incidently, I noted your comment on CopyTo and changed my code to reflect your tip. It didn't solve the problem but the results are quite interesting and I've been playing around with it.
The criteria is in column C.
CopyTo A1 only retrieved data from the first column.
CopyTo A1:D1 retrieved data from columns A to D.
CopyTo A1:H1 retrieved data from columns A to D and pasted accordingly. It also repeated the data from column D in column H.

Interesting, but I just can't get the data I want to extract from column H.

Thanks