Hi,
I need your help. I have almost hundreds of files in excel every month and I need to have a summary of that. Instead of opening every file and the usual copy paste method, can you give me a best and accurate way for me to do it..and not all data in each file were needed for my report. plus can i also get the file name of the data that will be insert in the summary file. thanks..
Yes Can be done.
Can you upload sample workbook?
Last edited by micope21; 04-24-2012 at 06:14 AM.
What is the range that needs to be copied?
Are these files stored in 1 folder in your system?
Also, each row that is copied should have the source file name next to it right?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks