Hi All, I was wondering is some one could help me out on using a
dropdown list.

What im trying to acheieve is that one of the work sheets contain
1000's of Items

Columns

A B
C

Ref Discription Unit Cost


Second Worksheet is going to be used to price items.


and the Sheets would contain following columns

A B
C D E

Ref Qty
Discription Unit Cost Total Cost


Under the Columns C i want a Dropdown list which looks up the Items
from the Worksheet with all items with in.

But what i would also like it to do is carry across the Item which is
selected Unit cost in the the column D Next to it.

How do i do this?

Regards

Dan Cawthorne