JujitsuBunny
New Member
Hello Chandoo! It's been awhile since I had a problem I can't solve but I know you're all smarter than I am with vba.
I need to create a dynamic data validation array where the cell value changes as the source does. Source is on one page, data validation on another, however the named range I use is not a single column and data validation area can vary in size of columns.
I've found other vba options here but can't seem to make any of them work as I need for multiple columns/rows as opposed to the single columns they are intended for. I'm not sure if I should link those examples or try to start fresh.
As the master data changes, the compiled names will change as well. After selecting the name in the validation drop-down, is it possible to change the chosen value within that entire range?
I need to create a dynamic data validation array where the cell value changes as the source does. Source is on one page, data validation on another, however the named range I use is not a single column and data validation area can vary in size of columns.
I've found other vba options here but can't seem to make any of them work as I need for multiple columns/rows as opposed to the single columns they are intended for. I'm not sure if I should link those examples or try to start fresh.
As the master data changes, the compiled names will change as well. After selecting the name in the validation drop-down, is it possible to change the chosen value within that entire range?