I am working with a workbook created by someone else where there are three
drop-down lists for Division, Region and State respectively. The lists for
the drop-down boxes are side by side, i.e. there are say 5 entries for
Division under column A, 10 for Region under column B and 50 for State under
column C. The boxes should work independently, but if I choose one of the
first 5 states in the States box, the Division and Region boxes will be
filled in automatically with the information in the same row as the state.
If I choose a state in rows 6 to 10, only the Division from those rows will
populate the Division box. Does anyone have a suggestion as to the reason
for this? I can't find any formula with Offset or Match, or anything in the
VBA code that would explain it.

Actually, what I would like to do is set these three list boxes so that if an
entry is made in one, the other two are blanked.

"Christine" wrote:

I am working with a workbook created by someone else where there are three
drop-down lists for Division, Region and State respectively. The lists for
the drop-down boxes are side by side, i.e. there are say 5 entries for
Division under column A, 10 for Region under column B and 50 for State under
column C. The boxes should work independently, but if I choose one of the
first 5 states in the States box, the Division and Region boxes will be
filled in automatically with the information in the same row as the state.
If I choose a state in rows 6 to 10, only the Division from those rows will
populate the Division box. Does anyone have a suggestion as to the reason
for this? I can't find any formula with Offset or Match, or anything in the
VBA code that would explain it.

Does this do what you want?
http://www.contextures.com/xlDataVal13.html
http://www.contextures.on.ca/xlDataVal01.html

Regards,
Ryan---

--
RyGuy


"Christine" wrote:

Actually, what I would like to do is set these three list boxes so that if an
entry is made in one, the other two are blanked.

"Christine" wrote:

I am working with a workbook created by someone else where there are three
drop-down lists for Division, Region and State respectively. The lists for
the drop-down boxes are side by side, i.e. there are say 5 entries for
Division under column A, 10 for Region under column B and 50 for State under
column C. The boxes should work independently, but if I choose one of the
first 5 states in the States box, the Division and Region boxes will be
filled in automatically with the information in the same row as the state.
If I choose a state in rows 6 to 10, only the Division from those rows will
populate the Division box. Does anyone have a suggestion as to the reason
for this? I can't find any formula with Offset or Match, or anything in the
VBA code that would explain it.