Hello

I thought I found a way of avoiding this problem but no such luck. Hence
further questions.

My source data is based around a large number of variables, i.e. I have over
600 manufacturers with some offering more than 400 products. Given this, can
Excel handle my request as the Contextures site requires you to lay out all
of the data in a pivot format so you can name each range?

Or is there an easier VBA way?

And given the manufacturers appear multiple times, how do I create a single
entry list for the primary DD list in the first place?

Hope this makes sense

Thanks, Arjay


"NoodNutt" wrote:

G'day Arjay

Check out this site:
http://www.contextures.com/xlDataVal02.html

Download the sample file, I used it on a spreadsheet at work & it works
fine.

Follow the instructions

HTH
Mark.