copy macro

[arnoldmiranda]

hi,
I have a huge dump file with data that runs into 1000's of rows and colums as much as CJ. I receive this file daily and what I am expected to do is copy 5 particular colums into another file which is a personal file which I have saved and keep pasting where the previous day ends. On the dump file the only field that has an input in every single row is the first column (A), so it's easy to do shift+ctrl+down arrow to copy and paste, however the other 4 colums have loands of blank cell so the entire effort becomes extremely labour intensive. I was hoping someone can help me with a macro to help me copy and paste these 5 colums into another file por sheet from where I can save the data easily into my personal file

Thanks

 

[prajul89]

Why don't you copy the entire column