Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Data in 3 other Workbooks via Macro
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Data in 3 other Workbooks via Macro
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 Corey .... wrote: 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.... -- Anthony Prescott http://www.apofficesolutions.co.uk Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
Using VB Code to update one workbook with data from 4 diffferent workbooks. | Excel Programming | |||
update data in workbooks through formula | Excel Discussion (Misc queries) | |||
Update links to other workbooks while running macro | Excel Programming | |||
Macro to update workbooks | Excel Programming |