Hi,

I am looking to create a macro which will pull data from an excel spreadsheet which name will change depending upon date.

Eg. Today the workbook is called "071011 Health" and i would like to copy from A2 to A1000 and paste into a worksheet named with todays date in DDMM format "0710" into cells A2 to A1000.

The issue i think will be the constant changing of file name.

Any help greatly appreciated.

Regards

Chris