Creating dropdown list and autofill

[xuivo]

Hi all,

I'm looking to do somthing that is out of my knowledge. Here is today challenge...

I have a list like that look like this :

Mech Part Offset Opening
Part 1 12 15
Part 2 15 42
Part 3 34 89

What I want to do is to create a dropdown list on an another sheet allowing to select the Mech Part (which I've done). Now, what I want if when I select let say "Part 1" from the list, I want the info associated with it to be shown in others cell.

Example.

I have the droplist in cell A1. When I select "Part 1", I want excel to write in cell B1 the correponding offset and in cell D22 the corresponding opening.

If anyone know, it would be greatly appreciated. I've been scratching my head for 3 hours now...

[jasoncw]

You can do everything on one sheet if you wish. Select any cell in the range, and then from the menu, select Data > Filter > AutoFilter. Reply back if this does not suit your needs.

[VBA Noob]

Hi,

Try Data valiadtion for the list and Vlookup for the return offset & opening.

These links explain how thye work

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlDataVal01.html

VBA Noob

[xuivo]

All right,

THanks for your link, it's now working perfectly!!!

[VBA Noob]

No problem

Thanks for the feedback

VBA Noob