Automatic Update to a Workbook from another workbook

chrisjack

New member
Joined
Oct 22, 2012
Messages
15
Reaction score
0
Points
0
I have a workbook called “Auto Parts” that has 2 tabs (MBS) & (Display). The “Display” worksheet has some vba code, when executed it gets it gets its data source from the “MBA” worksheet. This “MBS” worksheet was designed as a table named “tMBS” and gets its data source through Microsoft Query from another Excel spreadsheet in a different workbook. Everyday I have to refresh my “Auto Parts” workbook before running my Macro on the “Display” worksheet to create reports. If I want my “MBS” tab to automatically update itself whenever changes/Updates are made to the source how can I accomplish that so it can be always updated whether I am at work or not. Thanks in advance.

Note: This workbook is a Macro_Enabled_Workbook so is the source workbook also.
 
Top