Dependant Data Validation - for Whole Column
Hi,
Am trying to create a Excel template which user can download and fill in In the first column i have defined data validations to show all the country names. In second column, i have to define the validation based on its adjacent cell. I want to define it for entire column. Can any body tell me if this can be accomplished? |
Dependant Data Validation - for Whole Column
See http://www.contextures.com/xlDataVal02.html
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kumaresh Sierra" wrote in message ... Hi, Am trying to create a Excel template which user can download and fill in In the first column i have defined data validations to show all the country names. In second column, i have to define the validation based on its adjacent cell. I want to define it for entire column. Can any body tell me if this can be accomplished? |
Dependant Data Validation - for Whole Column
Dear Bob, Thanks for your reply.
Infact i had referred the below mentioned page. My scenario is I have a blank excel template. Users will download the same, select Country in first column and the very next cell should have list of states in it. Now when i select the column A and set data validation, it is working fine. But when i proceed for Column B and set validation for whole column, even the second row column B is referring to first row column A instead of second row Column A. Can this be resolved? "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal02.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kumaresh Sierra" wrote in message ... Hi, Am trying to create a Excel template which user can download and fill in In the first column i have defined data validations to show all the country names. In second column, i have to define the validation based on its adjacent cell. I want to define it for entire column. Can any body tell me if this can be accomplished? |
All times are GMT +1. The time now is 02:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com