How do setup an auto fill form
 

I have a setup of data on 1 work sheet and need the data to transfer on to
another worksheet automatically when I select a particular field from a drop
down menu in another worksheet in the same file.

My first worksheet holds all the data in 6 coloums a-f.

The second workshheet looks like a form with the first field to be filled in
as a drop down menu from data in sheet one. This has been done.

My problem occurs as I am unable to get the form to automatically fill out
once I have selcted the field from the drop down menu.

ie once I have I selected A23 (data from sheet 1) from the drop down menu on
sheet 2 I want it to put data from b23 (sheet1) in e12 (sheet2) and data from
c23 into f14 (sheet2) etc.

I would be greatfull for any help.

Thanks

Nick