Hi GS,

I understand where you are going with this but it wont work for my
data. This method relies on being able to break up the data into
separate lists and then reference the separated lists. Unfortunately
the data comes to me as a single long list.

I have seen a possible method using SMALL and MATCH as a way of
locating the relevant rows, but I am unable to get it to work. I dont
understand the the formula methodology to apply it correctly. An
example of the method can be seen he

http://fiveminutelessons.com/learn-m....WAeJmH8w.dpbs

Do you have any idea how I might apply this or something similar?

Cheers

The FRog

The example you link to has nothing to do with dynamic DV lists. That's
what you asked for and is what I spoke to. You must organize your data
to be usable in a DV list -OR- you could use VBA to organize it and put
it into DV lists for you. Either way, global scope named ranges need to
be used if the lists are on a different sheet than the DVs that use
them.

You don't say how many items are in the lists you get, but regardless
of list length the data must be restructured such that it *qualifies*
for use in DV dropdowns.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion