Ms excel problem: i have file having the naming of all of the retailers working under the company, now the pro?

ms excel problem: i have file having the naming of all of the retailers working under the company, now the problem is that, i have made copies of this sheet to other files also. whenever i update this file of the retailers, i have to update all of the copies of this sheet in other files. i want such a method that whenever i update my this file, the relative sheets in the other files are also automatically updated. Please help me.

Ms excel problem: i have file having the naming of all of the retailers working under the company, now the pro?
If you copy the sheet, it will make a one time copy of the content. There will not be any link between the copy and its original. You should maintain on file as masterlist keeping the updated retailers information. On other file that require such info, instead of copy the sheet, use formula as simple as "=" to tell excel that the file is equal to content from another file. Excel will pull the info from the masterlist file. If you update the masterlist file, all files that link to that file will be updated automatically or can be done manually by pressing F9 (Calculate)
Reply:For such kind of problem, I suggests you use Ms Access instead.


It's a database management system (while Excel is a tool performing tasks on spreadsheets), it helps you manage your data in a relational model.


Refer to the links below for more information and tutorials.