Hey Team,
I have a Dropdown list in Range("I1") that represents all Table Headers shown in Column B. What I would like to do is select one of the Table Headers from the dropdown list then run a VBA Macro to search column B for said Header. Once found and selected then offset selection down into the table and return the Table Name (List Object) of current selection to Range("J1").
Anyone have any ideas on how to do that?
I have a Dropdown list in Range("I1") that represents all Table Headers shown in Column B. What I would like to do is select one of the Table Headers from the dropdown list then run a VBA Macro to search column B for said Header. Once found and selected then offset selection down into the table and return the Table Name (List Object) of current selection to Range("J1").
Anyone have any ideas on how to do that?