Home

Creating Master Workbook/Sheet that reads and writes to different Workbooks/Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-759131%22%20slang%3D%22en-US%22%3ECreating%20Master%20Workbook%2FSheet%20that%20reads%20and%20writes%20to%20different%20Workbooks%2FSheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759131%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20create%20a%20department%20master%20workbook%2Fsheet%20that%20contains%20all%20data%20form%20different%20divisions%20workbooks%2Fsheets%2C%20with%20the%20capability%20of%20updating%20the%20data%20from%20both%20ends%20knowing%20that%20all%20the%20data%20categories%20are%20similar%2C%20only%20the%20divisions%20are%20different%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3B%20if%20I%20update%2C%20add%20and%20delete%20on%20the%20master%20workbook%2Fsheet%20the%20correspondence%20division%20workbook%2Fsheet%20get%20updated%20accordingly%20and%20vice%20versa%20if%20I%20update%2C%20add%20and%20delete%20in%20the%20division%20workbook%2Fsheet%20the%20master%20workbook%2Fsheet%20get%20updated%20accordingly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-759131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Saudi_Even
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies