Search column "header" an print the entire column in another worksheet

Hi

I have some logs with alot of columns (range A5:CQ:5), I need to read this range, and if it have some value print the entire column on another worksheet.
e.g.

Please Login or Register  to view this content.

Let's say I only need the columns "File" and "Point Number" to be printed on another worksheet named "Result", my idea was something like this

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Thanks for the reply.
If I run this code I get runtime error 9.
Dont know if its right but I changed "Destination:=Sheets("Select")" to "Destination:=Sheets("Result")" and now I get runtime error 1004

You made a correct change - sorry for my mistake. When you get the error, which line is highlighted in yellow when you hit the debug button?

OK - I can see the problem.

Please replace with

Please Login or Register  to view this content.

Thanks man, I just made it work using a less elegant aproach.

Please Login or Register  to view this content.

Thats ugly code but aparently worked haha