I'm using two combo boxes to select data.
On sheet1 I have data that refers to data on sheet2, sheet 3 and sheet4.
I need the combo 2 to be actualized with data on sheets 2, 3 and 4.
In combo 1 I select: BMW, Ferrari, Toyota.
I need combo 2 actualized with info in sheet 2: BMW320, BMW330, etc. In case i've selectes BMW on combo 1.
That means tha sheet2 refers to BMW, Sheet3 to ferrari, and 4 to toyota.
Thanks a lot.