• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Change Validated Cell when Source is Data Validation Changed/Updated

G

gjchandu

New Member
Hello All,

I got a question on Data Validation List

Scenario: In Sheet2 [Colum J] I got Data Validation Source and in Sheet 1 [Column C] I've set Data Validation List as Sheet 2 is source. I've already selected close to 5k Rows in Sheet1 with the list. Now I need to some changes/Updates in Sheet 2 Source. I was in assumption that Sheet 1 'already selected' values will automatically change. But it's not happening.

I've been through good number of blogs and didn't get the answer. Any help is much appreciated.
 
gjchandu
Try someway this way:
eg Sheet1 has 123 time text dog.
and You should change it to cat.
Use Find & Replace to find & replace all dogs to cats.
... repeat above with all Your some changes/Updates.
> If Your some is a lot ... then above manual procedure could do with Macro.
 
You must log in or register to reply here.
Back
Top