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

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

Debra has a nice tips on this address

try it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Terry" escreveu:

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

I would suggest google EXCEL-DATA VALIDATION-CREATE DEPENDENT LISTS
LOOK AT THE CONTEXTURES SITE www.contextures.com/xldataval02.html
--
Bucky F


"Terry" wrote:

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

I don't think you need dependent lists.

I think you just need a Lookup Table and some VLOOKUP formulas to fill in the
data based on Client name.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 14:19:00 -0700, Terry
wrote:

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