Questions:
1) Really?The master workbook I have attached is exactly the same layout as the individual workbooks
2) What sheet will be active when this "Master Workbook" opens?
3) What does the info on Sheets("001-New Acct Approval") in the workbooks that will be opened look like?
4) How many workbooks could you possibly be getting data from?
5) Have you read this http://www.excelguru.ca/content.php?184 ?
Bookmarks