Have a VBAcode:
Want the user to be able to select the variable "entity" by selecting a row in a combobox...
The combobox should have 2 columns with
Entity; Entityname
200 ; Google
201 ; Amazon
202 ; Microsoft
sub opentb()
dim wb1 as workbook
dim wb2 as workbook
set wb1 = activeworkbook...