Prev: edit CF in Excel 2007
Next: Counting Colored Cells that are Conditional Formated
From: Jim on 13 May 2010 12:15
Please help - I followed the directions at the site below to set up data
validation where the second list is based on the selection of the first list.
The first list works fine but the second list doens't have anything in the
dropdown, even though there are items on the list. The name box for the
dependent list matches one of the items on the first list. For the dependent
list, the data validation is set to List with the Source as =INDIRECT(A2). I
set all of column A with data validation for the 1st list and all of column B
for the second list. What other information do you need to help me figure
out where I went wrong?

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

Thank you,
Jim
From: Luke M on 13 May 2010 12:28
Hmm...
First, I'd make sure there aren't any extra spaces anywhere causing an
error.

Second, I'd goto Insert - Name - Define, and then click on the named ranges,
first the independent, and then the dependent (whatever is listed in A2)
Make sure they are referring to the correct things. You might also check to
make sure your have absolut reference (the little $ symbol) in the correct
spots.

--
Best Regards,

Luke M
"Jim" <Jim(a)discussions.microsoft.com> wrote in message
news:C1414C51-A90B-4C91-B8CC-5B93A3387AFB(a)microsoft.com...
> Please help - I followed the directions at the site below to set up data
> validation where the second list is based on the selection of the first
> list.
> The first list works fine but the second list doens't have anything in the
> dropdown, even though there are items on the list. The name box for the
> dependent list matches one of the items on the first list. For the
> dependent
> list, the data validation is set to List with the Source as =INDIRECT(A2).
> I
> set all of column A with data validation for the 1st list and all of
> column B
> for the second list. What other information do you need to help me figure
> out where I went wrong?
>
> http://www.contextures.com/xlDataVal02.html
>
> Thank you,
> Jim



From: Jim on 13 May 2010 12:39
I got this to work by just setting up row 2 and then dragging it down...

"Jim" wrote:

> Please help - I followed the directions at the site below to set up data
> validation where the second list is based on the selection of the first list.
> The first list works fine but the second list doens't have anything in the
> dropdown, even though there are items on the list. The name box for the
> dependent list matches one of the items on the first list. For the dependent
> list, the data validation is set to List with the Source as =INDIRECT(A2). I
> set all of column A with data validation for the 1st list and all of column B
> for the second list. What other information do you need to help me figure
> out where I went wrong?
>
> http://www.contextures.com/xlDataVal02.html
>
> Thank you,
> Jim
 | 
Pages: 1
Prev: edit CF in Excel 2007
Next: Counting Colored Cells that are Conditional Formated