Can you link multiple files to a parent file...
...so there is an automated update for the multiple files? Ok, I have an Excel 'Master" file that contains data that serves as a copy for all of the other individual "Client" files. My company has created a color coding system for organizing the "Client" files data, but I need the "Master" file to update when I change any of the "Client" files, and then have the "Master" file update all of the other "Client" files. In other words, I have files- (A)_(a)(b)(c).
Now when I change (c), I want it to update (A), and then have update (A) update (a), and (b). My concern is, I don't just want a re-copy of the Excel document, I want just the new information added to the other documents, because I still want to keep the information on (a), and (b) but need to add the new color data without disturbing, or replacing the file.
Any thoughts? Concerns? Is it even possible? (anythings possible, right?)
Cally
Bookmarks