Home

Need follow on tables to resize as master is adjusted

%3CLINGO-SUB%20id%3D%22lingo-sub-759606%22%20slang%3D%22en-US%22%3ENeed%20follow%20on%20tables%20to%20resize%20as%20master%20is%20adjusted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759606%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20master%20table%20that%20is%20a%20list%20of%20names.%20I%20have%20other%20tables%20that%20start%20with%20that%20list%20of%20names%20to%20do%20various%20calculations.%20How%20can%20I%20make%20the%20follow%20on%20tables%20resize%20when%20the%20master%20column%20changes%3F%20They%20all%20key%20off%20the%20names%20column%20in%20the%20master%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-759606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764840%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20follow%20on%20tables%20to%20resize%20as%20master%20is%20adjusted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764840%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20might%20want%20to%20look%20up%20the%20new%20array%20%26amp%3B%20%22formula%20spill%22%20on%20the%20insider%20program.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20however%20made%20an%20example%20using%20a%20VBA%20macro.%3CBR%20%2F%3E%3CBR%20%2F%3ECode%20used%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESub%20btn_PassValues()%3C%2FP%3E%3CP%3EDim%20Arr%20As%20Variant%3CBR%20%2F%3EArr%20%3D%20Worksheets(%22Sheet1%22).ListObjects(%22Table1%22).ListColumns(%22Name%22).DataBodyRange.Value2%3CBR%20%2F%3EWorksheets(%22Sheet1%22).ListObjects(%22Table2%22).ListColumns(%22Name%22).Range.Cells(1%2C%201).Offset(1).Resize(UBound(Arr%2C%201)).Value%20%3D%20Arr%3C%2FP%3E%3CP%3EEnd%20Sub%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(not%20good%20code!%20but%20it%20quick%20and%20easy%20reading)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20758px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123855i0FDDA89296B6870D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377942%22%20target%3D%22_blank%22%3E%40wnbrandt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
wnbrandt
Occasional Visitor

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

1 Reply

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)

Capture.PNG

 

Hope this helps?

 

@wnbrandt 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies