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?