Updating a VData List in all sheets by changing a DynRange?
Hello,
I am new to Excel and Google groups, so please be gentle m(-_-)m.
I have a raw_data sheet that has several lists that are linked through
InsertDefineName. These lists are used for Validation Data List drop
down menus in other sheets. What I want to do this be able to update a
list element in my raw_data sheet and have the corresponding element in
other sheets also update. Is this possible or is there another way to
do this?
Thank you for your help and have a happy day!
|