vba macro to copy data from multiple files

[akulka58]

Hhi,


I would like to thanks chandoo.org. this site helped me lot about excel tips and vba. thanks a lot.


I have found below code from this site only. the code is working fine, i just need few amendments in that. i am new in vba coding. i request you please help me in this.


CODE LINK- http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/


below is the issue


The code copy data from worksheet whenever workbook’s get opened. IT DOESN’T COPY DATA FROM SPECIFIC WORKSHEET.

how can i do that. need help


below is my second issue


if i add there COLUMN “L” in LIST TAB which contain SHEET NAMES. I need to COPY DATA FROM THAT SHEET WHICH IS MENTIONED IN COLUMN “L” IN LIST TAB.


last but not in list....


After copy pasting data from different workbooks I need code which FILTER DATA WITH CURRENT MONTH AND PASTE INTO SUMMERY SHEET. I need current month data only. Previous month data can be deleted from summary sheet EXCEPT HEADERS. When code pastes the data on summery tab it also WRITES SHEET NAME IN SUMMERY TAB COLUMN 1. It means from where the data has come.


REQUEST YOU PLEASE HELP ME IN THIS.


thanks

 

[naveed raza]

It would be great if u provide sample workbook

 

[SirJB7]

Hi, akulka58!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, if you haven't performed yet the search herein, try going to the topmost right zone of this page (Search...), type the keywords used in the title when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, as this is a widely posted question, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

Regards!