• 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.

Data Validation

W

webmax

Member
Hi

i have one doubt in Data Validation.

For Data Validation i type the list range in one place in excel (Cells)

For example in the attached file the list of range is E2 to E5

The Data Validation will come in C2 Range.

If any body wrongly delete the cells between E2 to E5. The data valdiation will not come.

Can u tell any other way to put the list within the Data Validation.


Regards
Shahul
 

Attachments

In the Data Validation List box instead of using a range
simply Type A,B,C,D
 
Hi Shahul ,

Another option is to use named ranges ; if you create a named range , and in the Refers To box type the address range , you can use the named range as the list for your DV drop-down. Even if rows / columns are deleted , the named range will still point to the list , and your DV drop-down will remain intact.

Narayan
 
You must log in or register to reply here.
Back
Top