Hi all,

I am looking for a Macro to open then copy data from an old file and paste into my present file.

Ideally the Macro can search for the old file but doesnt have to (old files are named using CCY and date i.e. AUD 01082010) (or just the previous day, weekends will not be included)

Data i need to copy is from A2 through to K2 going down to the last value in the columns.
This then needs to Paste into my present sheet in M3 .

Any help is much appreciated.