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.... |
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 |