Hello,

I have a list of names that I would like to use for a groupd of ranges.
Insead of typing each range name in the diaolgue box, is there a way to
upload or automatically use te list that I have created?

Beagle

You could use a dropdown list with Data Validation and possible a Vlookup
formula.
Please give me more details and I'll give you directions...

"Beagle" wrote:

Hello,

I have a list of names that I would like to use for a groupd of ranges.
Insead of typing each range name in the diaolgue box, is there a way to
upload or automatically use te list that I have created?

Beagle

Hi,

I'm using the DSUM function and have "many" criteria combinations. These
criteria combinations use Named Ranges. I have the names of each range but
would rather not type each name in the dialogue box (or Insert/Name/Define).

Is there a why to automatically/upload the names of the ranges?

Beagle


"FC" wrote:

You could use a dropdown list with Data Validation and possible a Vlookup
formula.
Please give me more details and I'll give you directions...

"Beagle" wrote:

Hello,

I have a list of names that I would like to use for a groupd of ranges.
Insead of typing each range name in the diaolgue box, is there a way to
upload or automatically use te list that I have created?

Beagle