iuliamihaela
12-18-2012, 07:43 AM
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 (which acts like a database).
Can someone please help me with this? All fv files are stored in the same folder.
Many thanks,
Iulia
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 (which acts like a database).
Can someone please help me with this? All fv files are stored in the same folder.
Many thanks,
Iulia