Dear Richard,

Thanks a lot for a prompt reply.

I want to extract the data from one sheet and paste to the other. When i use advanced filter then it pastes the criteria range as well but i am looking forward to pasting data only from the target ranges.

I would upload an example of my workbook, but not sure how to do that, could you please help me?

Cheers!!
Hem