Filter, copy specific columns, and paste to another sheet as VALUES ONLY

Hi guys, I know this must be a repetitive subject to you, but I just canīt make this work despite all the posts I read, so here it goes, and I really appreciate your help.

I took a code from this post: http://www.excelforum.com/excel-prog...ml#post2356294
I find it really helpfull, but now I need to copy only the values... not the formulas.

My code is as follows:

Please Login or Register  to view this content.

As I told before, the code works fine. I just need it to copy the values.

Thanks!

Try this:

Please Login or Register  to view this content.