Forum Discussion

niallfagan's avatar
niallfagan
Copper Contributor
Jun 24, 2020

Automatically pulling a sheet from another Excel workbook on startup

Hi all,

 

I am looking to see if it is possible to Automatically pull a sheet from another Excel workbook on startup.

 

So i currently have a work book with 2 sheets.

SheetA is a list of jobs, sheetB is a list of instructions and details for these jobs.

SheetA references the information in sheet B via a lookup table and pulls in the relevant data based on the job name.

The workbook is stored on a server and accessed by many people. Sheet B needs to be updated regularly with the latest procedures. There are multiple workbooks using this same method and all using the same Sheet B. When an update is required all workbooks must be updated with the latest rev of SheetB.

What i would like to do is when the workbook is opened it automatically pulls the latest version of SheetB from a "master" workbook with the latest information for sheetB in it.

I do not know of this is possible or if possible how difficult to implement. Looking for some advice form the experts 😉

 

Thanks in advance.

Niall

excel
Formulas and Functions
Macros and VBA

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 26, 2020
    In which location is Sheet B stored? If on a network share you can use Data, Get Data, From File, From Workbook. Do this on each file that needs the information and set those resulting tables to refresh on open. (Or do it once and copy the resulting table to each other workbook in turn)

Resources