Home

Linking between documents?

%3CLINGO-SUB%20id%3D%22lingo-sub-758615%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20between%20documents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758615%22%20slang%3D%22en-US%22%3EOnly%20Cost%20document%20loaded.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758538%22%20slang%3D%22en-US%22%3ELinking%20between%20documents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758538%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20I%20have%20two%20documents%20(procurement%20and%20cost)%20-%20as%20you%20can%20see%20in%20attached.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20procurement%20document%20groups%20quantities%20and%20sorts%20it%20into%20suppliers%20via%20a%20power%20query.%20Now%20I%20want%20the%20source%20of%20the%20power%20query%20(the%20quantities)%20to%20link%20to%20the%20cost%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cost%20document%20generates%20quantities%20based%20on%20sizes%20of%20the%20room%20-%20individually%20formulated.%20How%20do%20I%20get%20the%20cost%20document%20to%20autofill%20the%20procurement%3F%20Will%20there%20be%20any%20issue%20when%20i%20start%20to%20add%20more%20materials%20and%20more%20rooms%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBailey100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-758538%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%3CLINGO-SUB%20id%3D%22lingo-sub-758837%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20between%20documents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758837%22%20slang%3D%22en-US%22%3EThanks%2C%20Fixed%20this.%3C%2FLINGO-BODY%3E
Bailey100
Contributor

Hi,

 

Here I have two documents (procurement and cost) - as you can see in attached. 

 

The procurement document groups quantities and sorts it into suppliers via a power query. Now I want the source of the power query (the quantities) to link to the cost document.

 

The cost document generates quantities based on sizes of the room - individually formulated. How do I get the cost document to autofill the procurement? Will there be any issue when i start to add more materials and more rooms?

 

Many thanks,

 

Bailey100

 

2 Replies
Only Cost document loaded.
Thanks, Fixed this.
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