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

2011-09-20 Thread Ragavan
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 Date: Sep 20, 6:09 am Subject: Macro to open

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

2011-09-19 Thread Ragavan
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