Name Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Limit to Named Ranges 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Help With MS Access 4
simple question about excel 5
Deleting invisible range names - how? 3
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Can't located named range 3
Non-Contiguous Named Range? 2

Back
Top