Hi Lucas,
Is all your data in Sheet1 in all of your workbooks, or do they contain multiple sheets to be consolidated?
Hi Lucas,
Is all your data in Sheet1 in all of your workbooks, or do they contain multiple sheets to be consolidated?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'