code the following - down list to automatically fill table

Greeting to all ...

I have made a table like below:

in column "A" i have create product and under product i have 4 items like "Warehouse 01, Warehouse02, Showroom01, Showroom02.

In Row 02 i create area, and under each one of the above products there is 3 different area 01, Area 02, Area 03.

In column "G", i have create a drop down menu for all the product mentioned above, and in cell G11, G12, G13 are empty cells

My inquiry is: I want when I choose from this drop down list all the field in cells G11, G12, G13 automatically filled from the table above (refer to the attachment)

Thanks in advance
Blue_Sky_70

Hello blue_sky_70,

Welcome to the Forum!

To get a faster answer your question, please post your workbook in Excel 2003 format as well. More people will then be able to view your workbook and offer their assistance.

Sincerely,
Leith Ross