Hi, I have two columns A and B.
column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belong to the respective primary task. eg: in the attached spreadsheet, if i select "Admin / Reporting" in the list, in the other cell only the following sub-tasks should reflect: follow-up and reminder mails for Onhold/Offline/PCR records Metrics reports (for SKAs and above) Workplan preparation (for SKAs and above) Logistics for training (for Training SKA) Updating time entry reports Updating project tracker (for SKAs and above) Monitoring Service Desk (for SKAs and above) query resolution time b/w QA and KA query resolution time b/w KA and SKA Monitoring quals mailbox Updating KL tracker (for docs KL team) i hope this request is clear. let me know if you have any questions. your help is much appreciated. sharath -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
