20 excel workbooks every day to be summarized
 

Hi

I'm pretty new to macros hence please bear with me.
I receive 20 excel workbooks every day and are placed on to one folder. I
need to copy the data from a specific sheet and specific range from all
sheets in the folder and create a summary file. How to create a macro for
this?
Note : the folder in which these files go in to chnages everyday meaning to
say for every day there is a new folder created

Regards
Siddharth

20 excel workbooks every day to be summarized
 

This should get you to where you want to be:
http://www.rondebruin.nl/copy2.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Vasu" wrote:

Hi

I'm pretty new to macros hence please bear with me.
I receive 20 excel workbooks every day and are placed on to one folder. I
need to copy the data from a specific sheet and specific range from all
sheets in the folder and create a summary file. How to create a macro for
this?
Note : the folder in which these files go in to chnages everyday meaning to
say for every day there is a new folder created

Regards
Siddharth