Jul 17 2019 01:56 PM
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
Jul 19 2019 07:44 AM
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?