Copy files based on macro

I wonder if somebody could help me out with this issue.

I have an excel file with different columns. Column K contains filenames (different extensions).
Column J contains UNC addresses (Ex.: C:/whatever/test/pastithere)

What i want to accomplish is have a macro copying files (= the filenames in column K) from a fixed address on a server (Ex.: Y/whatever/test) to the address that is in column J, so filename K5 is copied to address J5, etc.

Is there somebody willing to help me out with this?

Thanks in advance

Hi
insert the source file path in the macro code and filename/destination filepath in col K & J and run the macro.
Ravi

I tried your file, but it doesn't seem to be working Ravi.

It does give me the "Copying is completed" message, but the actuall copying isn't happening