Spreadsheet help please
 

I have the following, in cells
A2 = Part Number B2 = Description C2 = Supplier D2= Lead Time E2 = Number
req F2 = Qty
What I,m trying to acheive is that in cell C3 there is a drop down menu that
you can pick one of 7 suppliers, depending on which one you chose i want it
to populate a requirement in D3
Is this possible, if so can you explain how

Thanks

Spreadsheet help please
 

Debra Dalgleish explains how to do this on her wonderful Contextures site:
http://www.contextures.com/xlDataVal02.html

Hope this helps,

Hutch

"Shane" wrote:

I have the following, in cells
A2 = Part Number B2 = Description C2 = Supplier D2= Lead Time E2 = Number
req F2 = Qty
What I,m trying to acheive is that in cell C3 there is a drop down menu that
you can pick one of 7 suppliers, depending on which one you chose i want it
to populate a requirement in D3
Is this possible, if so can you explain how

Thanks