Automatic Data Update on Different Workbooks (image)

[Juan Torres]

I have a workbook with a master list which contains the names of all the medical providers that work for an employer. However, the employer has 7 different facilities. Thus, I have separated these providers by creating 7 different workbooks lists which separate the providers into their respective facilities. I must constantly (2-3 times a week) update information in the 7 different workbooks and the master list workbook. For example, if I get updates on 15 medical providers who work at MLK Hospital, I need to go to the MLK Facility List and the Master List to update both lists (inputting data 30 times). To avoid updating two lists all the time I get new data, I want to find a way in which I can automatically update one list of the 7 workbooks and update the master list workbook (or/and vise-versa).

Extra information:

•Currently using Excel 2016.

Thanks!

 

[Hui]

I would update the master file and then use a macro to produce the separate files for each facility

Refer:

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/