Forum Discussion

Yepitsme1899's avatar
Yepitsme1899
Copper Contributor
May 08, 2023

Dynamic Table from two data worksheets

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

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Your question unclear. Attach a sample excel file. Show your input and desired output. Then explain , how to get that output.

Resources