Is it possible to create a drop down list, that once a value is selected it
will change a value in a range of cells? Example: Say I'm a plumber (ok,
your a....) I do work for a bunch of different clients. I get $1.10 for a
foot for pipe, $20 per faucet, etc. from client "A". I get $1.05 for pipe,
$25 per faucet, etc. from client "B". And the list goes on and on. Can I
take my bid form, create the drop down list, Pick client A,B,C whatever and
it will adjust the values accordingly. If cell A1 is my quantity and A2 is
the value I wish to multiply it by, I want A2 and every other cell, that has
a value for that particular client, to change to the corresponding value for
that client, when that client is picked from the drop down menu.
I want to eliminate the need to create several worksheets with different
values, and consolidate them into one.
Thanks