| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation across sheets
Hi all!
I know in order to use data validation on "sheet 1" using data on "sheet 2" i need to define a name. however, my list on "sheet 2" will constantly grow. is there a way that i can create the name dynamically so that i do not have to re-define the list every time a new entry is added and also not have the numerous spaces that a general range (say A1:A10000) would have? as an aside, my data on page 2 is added using a userform and vba - so i am thinking that it may be easiest to re-define the list through vba code every time page 2 is updated. am i thinking correctly? thanks! J |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation across sheets
You can use a dynamic name for the range. There are instructions he
http://www.contextures.com/xlNames01.html Gixxer_J_97 wrote: Hi all! I know in order to use data validation on "sheet 1" using data on "sheet 2" i need to define a name. however, my list on "sheet 2" will constantly grow. is there a way that i can create the name dynamically so that i do not have to re-define the list every time a new entry is added and also not have the numerous spaces that a general range (say A1:A10000) would have? as an aside, my data on page 2 is added using a userform and vba - so i am thinking that it may be easiest to re-define the list through vba code every time page 2 is updated. am i thinking correctly? thanks! J -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation across sheets
Perfect! Thanks Debra!
J "Debra Dalgleish" wrote: You can use a dynamic name for the range. There are instructions he http://www.contextures.com/xlNames01.html Gixxer_J_97 wrote: Hi all! I know in order to use data validation on "sheet 1" using data on "sheet 2" i need to define a name. however, my list on "sheet 2" will constantly grow. is there a way that i can create the name dynamically so that i do not have to re-define the list every time a new entry is added and also not have the numerous spaces that a general range (say A1:A10000) would have? as an aside, my data on page 2 is added using a userform and vba - so i am thinking that it may be easiest to re-define the list through vba code every time page 2 is updated. am i thinking correctly? thanks! J -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| How to set-up data validation between sheets? | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Validation for multiple sheets? | New Users to Excel | |||
| Data Validation Lists Across Sheets | Excel Discussion (Misc queries) | |||
![Gixxer_J_97[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
