Hi Check this..Open workbook, Click button to run macro & open folder in which you have files to import data & you are done..
PS: Keep all excel file in one folder & macro will port data one by one from all sheets & all workbook..... Do let us know if any error.. Cheers!! +++++ *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 4:11 PM, Murali Nagarajan <muralin...@gmail.com> wrote: > > Dear > All,I need your valuable help which will be reduce my time to compile > data without any errorRequirementMonth on month I received huge data base > from my Head office to compile and send the same to Respective managerAll > Sheets data formats are same so what I want from your side.plz make a > macro to compile Data in new sheet automatically and the the sheet name > should come between B and C Column (Column should create automatically).Please > delete 1st and 2nd row auto matically because data will be start from 3rd > row itselfNote:There are more than 15 files and each files contains > minimum 40 sheetsThanks & RegardsMurali.NChennai -600031 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Macro import data from multiple excel.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
