Jul 17 2019 01:29 AM - edited Jul 17 2019 05:07 AM
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