Marco to pull data from workbook by searching for date

**batchy** · 10-07-2011, 05:51 AM

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

**arlu1201** · 10-07-2011, 06:27 AM

You can include a command to ask the user to open the required file. Once the file is opened, you can have the macro search for the sheet containing today's date and then do the copy paste.

Does this work for you?

**batchy** · 10-07-2011, 07:14 AM

Hi,

If option A isnt available always willing to listen to option B :D

**batchy** · 10-10-2011, 04:47 AM

Can anyone one help with arlu's suggestion?

**Kyle123** · 10-10-2011, 04:51 AM

Hi Batchy, will the workbook always be stored in the same location, just a change in filename?

And how is the date calculated in the filename you are looking for? Is it the last working day?