Dependent list in excel to create validation
in [General]
|
Prev: Copy filename from Excel 2010 Recent Workbooks to Clipboard
Next: create hyperlink from exel file to particular word in word file
From: raghulvarma on 14 May 2010 21:45 I needs some info on dependent list in excel to create validation. Please find below my example. one work sheet has the employee details in two different columns(A and b) master data. Eg; sat - Manager sai - DBA sss- Manager xx - Team leader AA- Senior programmer. i want to implement the validation in another worksheet based on the above master data. Eg: This sheet has 3 columns. Designation, Employee name and Salary, Once i type the designation in that column then Employee list needs to filter based on the inputted designation. Example if i enter Manger then employee list needs to display sat and sss only. it should not allow other names. Please Note: Macros are not allowed We are planning to extract the data from the database, we don't know what will be the master data, master data may change at the time of each page load, is there a possibility to load the list with select query?
From: Dave Peterson on 15 May 2010 07:22
I'd start by reviewing the notes at Debra Dalgleish's site: http://contextures.com/xlDataVal02.html On 05/14/2010 20:45, raghulvarma wrote: > I needs some info on dependent list in excel to create validation. Please > find below my example. > > one work sheet has the employee details in two different columns(A and b) > master data. > Eg; > sat - Manager > sai - DBA > sss- Manager > xx - Team leader > AA- Senior programmer. > > i want to implement the validation in another worksheet based on the above > master data. Eg: This sheet has 3 columns. > Designation, Employee name and Salary, > > Once i type the designation in that column then Employee list needs to > filter based on the inputted designation. Example if i enter Manger then > employee list needs to display sat and sss only. it should not allow other > names. > > Please Note: Macros are not allowed > > We are planning to extract the data from the database, we don't know what > will be the master data, master data may change at the time of each page > load, is there a possibility to load the list with select query? |