20 excel workbooks every day to be summarized

V

Vasu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
VBA - exporting serial letters to single documents 0
summarizing data from various workbooks 4
Help with MACRO for opening workbook 1
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook 3
VBA Macro to Create Sheets Based on Column of Values 1
Sort data from every workbook in a folder into sheets in another? 1
Custom Document Properties in Word documents and Excel workbooks 15

Top