Dynamic Table from two data worksheets

Copper Contributor

Hi everyone

 

I have one table that looks like this:

Yepitsme1899_0-1682993829053.png

 

I have another table that looks like this

Yepitsme1899_1-1682994093597.png

 

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.