A column contains category e.g brand name of cars
b column contains detail description e.g. colours of related cars or model no
how can i use VBA so that if user select specfic brand name of car only specific
detail of col "B" will show in data validation popup - or there is any other way
out