i have 2 list boxes,if i select a value from the second listbox and press button it should generate a report in the next sheet with all the values in the first listbox
for ex:
Listbox1:blue
white
red
listbox2:card
ecommerce
sap
button

If i select a value from listbox2 and press the button it should generate a repot in another sheet for blue,white and red for that particular listbox2 value

Thanxs in advance.
Pranu