How to make a dynamic named range
Hi everybody,
Can I make a named dynamic range? I am using data validation and made some
lists to work with but the problem is I have to change the range by the name
define command as I use a new list item. I have used the offset function to
create the dynamic list but is there any way to use a named list in that way?
|