Dynamic Table from two data worksheets

Copper Contributor

Hi everyone


I have one table that looks like this:



I have another table that looks like this



If possible, I would like a dynamic table that gives one row per item/warehouse that only gives the ordered and available quantities (summed by the item/warehouse) for only the GS Storage and Blank locations.


Thanks for your help

1 Reply
Your question unclear. Attach a sample excel file. Show your input and desired output. Then explain , how to get that output.