Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependant Data Validation not sorted | Excel Worksheet Functions | |||
Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
copy dependant validation cell | Excel Discussion (Misc queries) | |||
Dependant Data Validation List | Excel Discussion (Misc queries) | |||
Data Validation dependant and unique | Excel Worksheet Functions |