Copy Paste Special Using Column Headers

I'm using the following code to copy/paste data from one workbook to another using the header values. It works, but I'm needing it to paste special. Any ideas?

Please Login or Register  to view this content.

Thanks!!

Change

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

It works! Thanks so much for your help.