LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default data validation, dynamic ranges

can you help please?

i have the following

cell C3 = data validation from a fixed range (5 drop down options)
cell C6 = data validation drop down - the choice in C3 determines the list
in drop down in cell C6 (i.e. 1 of 5 different list will appear in the drop
down)

the 5 lists which are determined by cell C3 are all dynamic ranges named,
lets call them apple, pear,orange, grape and plum.

these 5 named ranges are the same names as the drop down options in cell C3.

For some reason it doesn't work using indirect because of the formula, is
there a way to make this work?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation and Dynamic Ranges GSB Excel Discussion (Misc queries) 2 July 17th 07 06:24 AM
Dynamic Data Validation tmirelle Excel Discussion (Misc queries) 1 March 20th 07 03:21 AM
data validation invalid in dynamic validation list ilia Excel Discussion (Misc queries) 0 November 7th 06 12:54 PM
data validation invalid in dynamic validation list ilia Excel Worksheet Functions 0 November 7th 06 12:54 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"