data validation across sheets

[Guest]

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]

You can use a dynamic name for the range. There are instructions here:

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

 

[Guest]

Perfect! Thanks Debra!

J

You can use a dynamic name for the range. There are instructions here:

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