I need to be able to dynamically set the valid range of selectable values in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box (using
DataValidation), I need the cell to the right to restrict its possible range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.

Hi Scott

Create named ranges corresponding to each of your 6 digit numbers, each
containing the list of valid entries.
If your first validation is in A1, set the validation in B1 to be List
Source =INDIRECT(A1)
For more help look here
http://www.contextures.com/xlDataVal02.html
--

Regards
Roger Govier

"Scott K" <Scott wrote in message
...
I need to be able to dynamically set the valid range of selectable values
in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box
(using
DataValidation), I need the cell to the right to restrict its possible
range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.

See Debra Dalgleish's explanation and instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Scott K" <Scott wrote in message
...
I need to be able to dynamically set the valid range of selectable values
in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box
(using
DataValidation), I need the cell to the right to restrict its possible
range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.

Hi Scott,

Maybe this site will point you in the right direction..

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

Hope this helps,

Gav.

"Scott K" wrote:

I need to be able to dynamically set the valid range of selectable values in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box (using
DataValidation), I need the cell to the right to restrict its possible range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.

Thanks to everyone who replied and sent me to
http://www.contextures.com/xlDataVal02.html. This was exactly what I was
looking for and it works great!

Regards,

Scott Kling

"Ron Coderre" wrote:

See Debra Dalgleish's explanation and instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Scott K" <Scott wrote in message
...
I need to be able to dynamically set the valid range of selectable values
in
a second cell based on the value entered in the first cell. Specifically,
when my users select a six-digit account number from a drop-down box
(using
DataValidation), I need the cell to the right to restrict its possible
range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.

Glad we could hellp, Scott.......Thanks for letting us know.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"Scott K" <Scott wrote in message
...
Thanks to everyone who replied and sent me to
http://www.contextures.com/xlDataVal02.html. This was exactly what I was
looking for and it works great!

Regards,

Scott Kling

"Ron Coderre" wrote:

See Debra Dalgleish's explanation and instructions on using Dependent
Lists:
http://www.contextures.com/xlDataVal02.html

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Scott K" <Scott wrote in message
...
I need to be able to dynamically set the valid range of selectable
values
in
a second cell based on the value entered in the first cell.
Specifically,
when my users select a six-digit account number from a drop-down box
(using
DataValidation), I need the cell to the right to restrict its possible
range
of selectable values based on what account number was chosen.

I am using Excel 2003 and I have a good bit of experience using VBA if
that's the tool I should be using.