Hi Eldacan. Couple of thoughts:
- I avoid doing VLOOKUPS across files. My preference instead is to put all the data in one table in one file, and use a pivottable to do my aggregations.
- If this will make the file too big, I'll maybe use a bit of VBA and SQL (a database language that Excel understands) to mash up the totals I need directly from the source files. THis avoids the use of any hard-coded formulas whatsoever. For examples of this approach see http://blog.contextures.com/archives...ultiple-files/ and http://blog.contextures.com/archives...n-pivot-table/
- I'm not really familiar with Data->Edit Links. But maybe instead of using Data->Edit Links you could instead do a global find and replace each month, replacing the old FILE_1 and FILE_2 address with the new FILE_1 and FILE_2 addresses.
Bookmarks