Hi

I have to copy data from one excel to another. The source filename from where I copy the data varies everytime.
I have to copy data from multiple columns from the source file and should be pasted to a sing file (this file remains the same). Everytime the macro should go to the source data file and filter some column and copy the =sum(...) at the top row and paste it in another file.
Any help ?