2 Way Connection between Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2497294%22%20slang%3D%22en-US%22%3E2%20Way%20Connection%20between%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2497294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIs%20it%20possible%20to%20set%20up%20a%202%20way%20connection%20between%20different%20workbooks%3F%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20for%20example%20I%20have%20200%20individual%20spreadsheets%2C%20which%20I%20need%20to%20manipulate%26nbsp%3Bthe%20data%20in.%20I%20want%20to%20copy%20all%20the%20data%20from%20each%20spreadsheet%20(all%20are%20in%20same%20layout)%20into%20a%20master%20spreadsheet%2C%20then%20make%20changes%20within%20the%20master%20spreadsheet%20which%20will%20then%20update%20the%20individual%20spreadsheet.%20Reason%20for%20this%20is%20I%20need%20the%20individual%20spreadsheets%20to%20be%20up%20to%20date%20so%20I%20can%20import%20back%20into%20a%20system%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2497294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2497357%22%20slang%3D%22en-US%22%3ERe%3A%202%20Way%20Connection%20between%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2497357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091043%22%20target%3D%22_blank%22%3E%40MattHoper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20far%20too%20complicated.%20Either%20update%20the%20master%20spreadsheet%20from%20the%20individual%20ones%2C%20or%20the%20other%20way%20round%2C%20not%20both%20ways.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is it possible to set up a 2 way connection between different workbooks?

 

So for example I have 200 individual spreadsheets, which I need to manipulate the data in. I want to copy all the data from each spreadsheet (all are in same layout) into a master spreadsheet, then make changes within the master spreadsheet which will then update the individual spreadsheet. Reason for this is I need the individual spreadsheets to be up to date so I can import back into a system

2 Replies

@MattHoper 

That is far too complicated. Either update the master spreadsheet from the individual ones, or the other way round, not both ways.

Hi Hans, I see where you are coming from however moving the data into the master, will allow me to filter all data then input the new data I need but I need the individual's one's to be kept up to date aswell so I can import back into system. (Each spreadsheet is room data for a buidling)