Update Data in 3 other Workbooks via Macro

[Corey ....]

I have 3 separate Workbooks i have setup that store BUY/SELL prices etc
among other data.

I have found that sometimes 1 user updates their BUY/SELL prices in their
workbook, but really the other 2 Users workbooks need to be updated also to
reflect the same values.

So i was thinking of Creating a SEPARATE Workbook that ONLY has 1 sheet to
Display the BUY/SELL values.

If ANY changes are made to this workbook Sheet, then i want to via a Macro
UPDATE the Users BUY/SELL values accordingly.

How do i Identify the Users Workbook and then UPDATE the values, then CLOSE
them again by running 1 section of code?

I am not sure where to begin.

Corey....

 

[Crowbar via OfficeKB.com]

I can see what your after doing here.

Do you know how to create a macro?

If you do, I would have a MASTER workbook with your buy/sell stuff in it.
This book wouldn't contain any macros

I would then create another book that has an update button
This update button would open the master and read the values you have stored
and change them

Hope this makes sense,

www.apofficesolutions.co.uk