Hi,

I need a macro which copies all data from different files to a worksheet. To be more specific - I have a worksheet for each day which contains 4 columns. The naming convention for the files is "fv-DD-MON-YY" (fv-12–Dec-12). I need to be able to input a period of time and all files that contain in the name a date in that period of time to be copied chronologically in a single worksheet.

Can someone please help me with this? All fv files are stored in the same folder.

Many thanks,
Iulia