Posted by Don on January 10, 2002 2:01 PM
I've made 52 workbooks, each containing an expense report spreadsheet. Each is named with week ending dates ex. jan6-2001 and jan13-2001. Each spreadsheet is identical. I need to combine all of the workbooks into one year end summary. Is there any way to do this using a simple formula seeing as they are all different workbooks and not simply different worksheets contained in one workbook? Any help for this old dumb sales guy would be greatly appreciated!