Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheet validation
hi,
My qn is completely based on excel sheet.It contains fields like country,state,city.From a table iam retreiving the values of country which is given in the country table in SQL server 2005 and displaying it in a ddl. The state table is linked with country table using a foriegn key.After a user selects a country wen he go for the nxt field -state it should display the the states in that corresponding country.I can able to retreive the country values nd display in a ddl but state.. i cant. I am using this excel sheet for bulk uploading of data using ASP.net nd c#. I am doing the above thing using data validation part by making a connection with db and retreive all the country names and display it in a column in excel sheet from their we are retreivin and showing it in a drop down list(ddl). Pls help me... i am new to this forum Thank You... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheet validation
See Debra Dalgliesh's explanation on dependent drop-downs
http://www.contextures.com/xlDataVal02.html "Renjith R" wrote: hi, My qn is completely based on excel sheet.It contains fields like country,state,city.From a table iam retreiving the values of country which is given in the country table in SQL server 2005 and displaying it in a ddl. The state table is linked with country table using a foriegn key.After a user selects a country wen he go for the nxt field -state it should display the the states in that corresponding country.I can able to retreive the country values nd display in a ddl but state.. i cant. I am using this excel sheet for bulk uploading of data using ASP.net nd c#. I am doing the above thing using data validation part by making a connection with db and retreive all the country names and display it in a column in excel sheet from their we are retreivin and showing it in a drop down list(ddl). Pls help me... i am new to this forum Thank You... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation works in one sheet but not another | New Users to Excel | |||
Data validation dropdown: works in one sheet, not in another | Excel Discussion (Misc queries) | |||
Data Validation fromanother sheet | Excel Discussion (Misc queries) | |||
Apply Validation on a protected sheet | Excel Discussion (Misc queries) | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) |