Re: Named of Named Ranges for validation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 13:29:56 -0400

I have a sample workbook that does what you describe. It might give you
some ideas.

   http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Combine Multiple Lists into One'

VT wrote:
> I have the following scenario that needs your assistance:
>
> In different sheets, I have named ranges of Fruits, Vegetables, etc.,.
> These named ranges are dynamic, using OFFSET formula to limit the values. I
> want to combine them to a sort of a multiple named ranges, calling it
> Produce, then use this in a cell list validation format. Only the data in
> the sub named ranges should be available on this list. 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Relevant Pages

  • Re: Can INDIRECT function reference a cell that contains a formula
    ... "Biff" wrote: ... Let's take the bracket lists as an example. ... The exact formula that I entered in the data validation formula bar ... List the named ranges somewhere,say, G1:I1. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can INDIRECT function reference a cell that contains a formula
    ... Let's take the bracket lists as an example. ... The exact formula that I entered in the data validation formula bar ... even though cell AC18 evaluates to listA... ... List the named ranges somewhere,say, G1:I1. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Data Validation and Filtering
    ... Within the list are a number of fields, most with drop down lists ... from left to right the data validation fillters the choices the user ... Female, the next selection is Category, data validation only allows the ... I obviously can't addopt the same approach of named ranges as I would ...
    (microsoft.public.excel.programming)
  • Data Validation and Filtering
    ... Within the list are a number of fields, most with drop down lists ... from left to right the data validation fillters the choices the user ... Female, the next selection is Category, data validation only allows the ... I obviously can't addopt the same approach of named ranges as I would ...
    (microsoft.public.excel.misc)
  • Data Validation and Filtering
    ... Within the list are a number of fields, most with drop down lists ... from left to right the data validation fillters the choices the user ... Female, the next selection is Category, data validation only allows the ... I obviously can't addopt the same approach of named ranges as I would ...
    (microsoft.public.excel.programming)