Create a drop down list using data from different worksheet and auto-populate the remaining cells

[adorlytanglao]

I have two worksheet. One worksheet is a form where in the Field Door No. should be a dropdown list. The list will be retrieve from worksheet Source. Now upon selecting a specific Door No. it should also autopopulate the respective Type, Brand, Serial No., and Type.

First thing i need to know is what should i do on Cell B1 worksheet Form for it to be a drop down list retrieving the Column A on worksheet Source.

Second, upon selecting for example ATC0009 on the drop-down, it should auto-populate like these

Door No. ATC0009
Type AT Crane
Brand A
Serial 43679
Type Crane


https://skydrive.live.com/#!/edit.aspx?cid=D4827519E16B978B&resid=D4827519E16B978B!402&app=Excel

 

[adorlytanglao]

bump no response