help in combo box and drop down menu

[uditmathur]

Dear Friends,

I have uploaded the excel on which i need help.
There is a tab sheet master in which i want to do all the data entry in the combo box.

There are 2 dropdown buttons.
I want help in the following things:

Dropdown 1 - indicates Particulars like Rollers/Paints/Canvas
I want that when i chose rollers in dropdown 1 then in dropdown 2 the list of item from cell Q2:Q3 should appear.
If i select Paints in dropdown 1 then in dropdown 2 the list of items from cell R3:R6 should appear so on and so forth.

i also want to enter the quantity and amount in the below text boxes.

Once i click on submit i want that according to the selection of dropdown 1, the complete data should be put in rows in the respective worksheet.

Example- if i select Paints in dropdown 1, Black from dropdown 2, 4 in quantity and 200 in price, after clicking on submit, all details should be automatically stored in the Wroksheet named "Paints"

Please help me someone.

Reagrds,

Udit