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
Highlighted
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
Highlighted
Only Cost document loaded.
Highlighted
Thanks, Fixed this.
Related Conversations