Dynamic Update Table from other Table

[erice]

Hello,

I think this is an easy solution, but I am struggling to figure it out with tables. I have a Table (Daily_QTY) that the user will populate the QTY column in daily. Since they are going to use that table daily I want to keep the Items in the same order to speed up their process. I am then wanting to take the data from the Daily_QTY Table and have it automatically update into the Daily_Calcs Table. The Daily_Calcs Table will be filtered and then have other macros ran through it. I keep getting a #SPILL! error when trying to use =Daily_QTY[Item]. I did find a solution that works somewhat in columns J:K, but am limited to how far down the formulas are drug.

Image 3.PNG

[Fluff13]

Convert the Daily_Calcs table into a normal range & the formula will work.
You cannot have spill ranges in a table.