How to fix : vba runtime error 1004 application defined or object ...

Hi, I have been working on a set of data in excel for the past few days now. I am using a custom filter to get the data i want and then paste that.

www.mrexcel.com