copy specific column to another sheet after filtered data without header

[pmchris]

Hi

My code below works fine, but it copies all data to another worksheet. My data has 21 columns. When I execute the following code, it copies all 21 columns data without header to another worksheet. so if I just want to copy data in column 2 and column 21 without header to another worksheet, how do I modify the code?

Please Login or Register  to view this content.

[JBeaucaire]

Maybe something like this:

Please Login or Register  to view this content.

[pmchris]

This works great. Thanks a lot.