Need follow on tables to resize as master is adjusted

[wnbrandt]

I have a master table that is a list of names. I have other tables that start with that list of names to do various calculations. How can I make the follow on tables resize when the master column changes? They all key off the names column in the master table.

Thanks

[#2]

You might want to look up the new array & "formula spill" on the insider program.

I however made an example using a VBA macro.

Code used:

Sub btn_PassValues()

Dim Arr As Variant
Arr = Worksheets("Sheet1").ListObjects("Table1").ListColumns("Name").DataBodyRange.Value2
Worksheets("Sheet1").ListObjects("Table2").ListColumns("Name").Range.Cells(1, 1).Offset(1).Resize(UBound(Arr, 1)).Value = Arr

End Sub

(not good code! but it quick and easy reading)

Hope this helps?

@wnbrandt