Linking with Master Worksheet

[yg1935]

I have a master price sheet that I keep but I would like to distribute copies of this sheet for others to use. This sheet changes often - Is there anyway to make my sheet the master and any changes that I make automatically link and change to the copies of the sheet that others are using?

Also...people use "adder pages" to up their prices to their specific price sheets. I'm having a hard time understanding how to make this all work together so any advice that you Excel guru's can provide is GREATLY appreciated!

 

[RalphA]

Your need sounds like a commercial application. Perhaps you should consult with professionals, such as those in the second line at the bottom of this screen, where it reads, "Need extra help ?...". Clicking on the Consulting Team link there will take you to
http://www.mrexcel.com/consult.shtml

 

[seenfresh]

I agree with Ralph

It seems this is a universal project of decent importance and you should consult a team in order to program this properly... the worst thing would be distributing various documents to others and having problems you cannot fix because this forum is mostly a one way interaction -- people help fix your problem-- but if you do not understand how to fix any possible contingencies (or understand the concepts presented to you) then you are right back were you started... Do you have a network that all users can access... if not this may be your first desired step... Then you can have this desired "Master" workbook that others can access open to all (at this point you can restrict the types of access to this "Master" wb through -- Protect and Share Properties of the WB--, this way your users will have constant access to your "Master" WB...

Hope this helps,