Hello, greetings for the day.
how do i go about having the user select the field from one table from a listbox and use it to populate field from another table. below example where tables are not joined.
Table A
Name City1 Region
Peter New York US
Shawn London EU
Loren Boston US
Stacy New York US
Trace London US
Table B
City2 Value
New York 5
London 4
Boston 7
so the listbox would be for Name field where a user can select multiple values. based on it all tables in the sheet would filter on the corresponding city values. However it should only filter if name is selected from the listbox.