I have a question on how I could populate data using a combo box selection in Excel 2010.
For example,
I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.
Maybe to make it clearer...
Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998
Combo box (selection of names): John
Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998
Any help on how I could solve this would be greatly appreciated
Also, do let me know if this can be done without the use of VBA.
Bookmarks