Hi How many rows may be Consolidated ?? I mean may be it can cross limit of Excel.
Regards Rajan. -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vitorjose Sent: Jan/Thu/2012 07:41 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Merging Sheets from Multiple files Thanks in advance for your help - i am looking for some vba code to accomplish the following I have approx 200 workbooks which have been created from a master template and should be identical. Each one represents a budget for a specific property location. They are located in multiple folders (each folder represents a geographical region) in a master folder called C:\data\ Each workbook contains a worksheet called "FMI" I would like to create a consolidation workbook which contains the "FMI" worksheets from each of the 200 budgets. As each worksheet is copied over i would like the sheetname to be changed to the value located in cell "B2" of the FMI tab - this is the property ID Some of the Data on the "FMI worksheet is linked to other sheets within the budget workbook so i would need to change the data in cell "B1 to C30" to values I hope that my explanation is sufficient to create the code Thanks again for your help -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com