Multiple customers that have different price quotes
You need to create separate lists for each customer and name them
(InsertNamedefine...), probably with the customer name, and then in
dependent Data Validation use a type of List, and a formula of =INDIRECT(D4)
where D4 is the initial Data Validation cell.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Pete Elbert" wrote in message
...
D7 has a dropdown list with customer names (10 -12 customers). F16 thru
F38
each have a dropdown list with a vlookup of a products list. Infomation in
columns H thru L are dependent on the product that is shown in cells F16
thru
F38 for unit size, price and extended price. The dilema is that all of
the
customers do not have the same pricing. How can I make the cells in F-16
thru F-38 reflect the product and all the associated pricing info for
which
ever customer I select from the dropdown list? Can it be done? Pete
|