View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] powertoold@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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!