Juan Torres
New Member
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!
Extra information:
•Currently using Excel 2016.
Thanks!