asingh
11-05-2008, 03:24 AM
Hi,
I have a data validation list - A, which is refreshed off another data validation list - B.
The list values for A are from a dynamic named range generated as per the selection on B. Now the data validation list A, is getting refreshed as I want it to, but not immediately visible, till I do not go and click on list A.
Any way I can resolve this, and make it more user friendly..??
So if I choose 1 on list B I get a list of a,b,c,d on list A. But this is not immediately visible (i.e. the first entry)..till I actually do not go and click on list A)
thanks a lot for the help..
asingh
I have a data validation list - A, which is refreshed off another data validation list - B.
The list values for A are from a dynamic named range generated as per the selection on B. Now the data validation list A, is getting refreshed as I want it to, but not immediately visible, till I do not go and click on list A.
Any way I can resolve this, and make it more user friendly..??
So if I choose 1 on list B I get a list of a,b,c,d on list A. But this is not immediately visible (i.e. the first entry)..till I actually do not go and click on list A)
thanks a lot for the help..
asingh