Hi Ashish THanks for the macro. As I said my MS Office does not work at home, I will try this at office and let you know the results. I am very grateful to you for lending me an helping hand in such situation.
THanks once again, Subramanian V On Wed, Sep 21, 2011 at 6:05 AM, ashish koul <koul.ash...@gmail.com> wrote: > see if it helps > > > On Wed, Sep 21, 2011 at 5:57 AM, Ragavan <ragav.ku...@gmail.com> wrote: > >> Hi All, >> >> I would like to bring to your kind attention that this is a very >> urgent work and is pending from my side for a long time. Also there >> are thousands of workbooks to be consolidated and hence manual >> consolidation cannot be considered as a proper option. Hence kindly >> request you to provide solutions to this as early as possible (if >> possible within the next 2 hours), as I have no mail access in office >> and need to take the code from home to office to get it working. >> >> Hope you all understand my situation (you all would have been in >> similar circmstances in your life) and provide me the solution asap. >> I know the comptenct of this group and also the helping tendency and >> trust that I will not be let down today. >> >> Thanks once again for the effort you put in this. >> >> Thanks, >> Subramanian V >> >> >> ---------- Forwarded message ---------- >> From: Ragavan <ragav.ku...@gmail.com> >> Date: Sep 20, 6:09 am >> Subject: Macro to open file from a location and consolidate data >> (Please dont consider this as a Duplicate post) >> To: MS EXCEL AND VBA MACROS >> >> >> Hi all, >> >> I have an urgent requirement for a macro that can open all the files >> from a path provided in a cell in excel work book and copy the >> contents from Columns A to K (consolidated data) in the new workbook. >> Kindly provide me the code to perform this operation, so that I can >> modify it according to my needs. Currently my MS Office is not >> working as expected and hence asking this help from you in the hope >> that I will get an solution to my problem. Thanks in advance for >> those who spend time in getting the code for me. >> >> The situation is this. I will have multiple files stored in C:\MyData >> \Sep2011\. I need to have one file (New one with the macro in it), >> wherein I have to open this workbook and provide the path in a cell >> say C2. Once I provide this path and click the execute macro, I need >> the macro to open all the individual workbooks in the path (all >> workbooks will be of same format) and copy columns A to K and start >> pasting in this new workbook. When the macro goes to the next work >> book and opens it, it has to append the data in the next row where the >> earlier workbook's data has ended. For e.g. if Workbook A has 50 rows >> of data and the macro has copied data frmo R5 to R55, when it opens >> the second workbook, it should add the first row from the second >> workbook to R56. likewise it has to open all the workbooks, >> consolidate the data and put it in. THis is my requirement. i >> request you to build the code for this functionality and send me the >> code such that i can use it to consolidate 1000s of indiidual files >> into one single file. >> >> I understand this is a very urgent request and my MS Office has >> stopped working (crashing very often) and hence would be grateful to >> you all if this gets accomplished. Thanks in advance to those who >> spend their valuable time in looking at this thread and trying out the >> macro for me. Request you to not consider this as a Duplicate Post, >> becos I have tried to provide the requirements elaborately as possible >> here. >> >> Thanks a milllion once again in advance from, >> Subramanian V >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > > > P Before printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel