Re: $$Excel-Macros$$ Fwd: Macro to open file from a location and consolidate data (Please dont consider this as a Duplicate post)

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 wrote

$$Excel-Macros$$ Macro to open file and copy information from worksheet

hi all, I have an urgent requirement for a macro that can open all file 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 m