Jul 17 2019 07:30 AM
Hi
How can I create a department master workbook/sheet that contains all data form different divisions workbooks/sheets, with the capability of updating the data from both ends knowing that all the data categories are similar, only the divisions are different?
For example; if I update, add and delete on the master workbook/sheet the correspondence division workbook/sheet get updated accordingly and vice versa if I update, add and delete in the division workbook/sheet the master workbook/sheet get updated accordingly.