drop down list that changes the data of 3 other cells
 

I select a customer from a drop down list and on selection I need 3 discounts
to be input into the three cells below. These vary from customer to customer
any ideas how I can do This?

It sounds like an issue where VLOOKUP can be used (to see how to use VLOOKUP
go to http://www.auditexcel.co.za/lookupandreference.html ). Have 3 vlookup
cells that make reference to the drop down customer name and pull through the
relevant discounts. If I have misunderstood please rephrase your question.

"Mark R Burgess" wrote:

I select a customer from a drop down list and on selection I need 3 discounts
to be input into the three cells below. These vary from customer to customer
any ideas how I can do This?

You can create a list with the customer names and their discount
amounts. For example:

Customer Disc1 Disc2 Disc3
ABC Co 5% 10% 12.5%

Then, on in the cells below the customer dropdown list, you can use
VLookup formulas to return the discount amounts. There's a similar
example here, using address information:

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

See the "Ship to" instructions are at the end

For more information on VLookup, see Excel's Help, and he

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


Mark R Burgess wrote:
I select a customer from a drop down list and on selection I need 3 discounts
to be input into the three cells below. These vary from customer to customer
any ideas how I can do This?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html