$$Excel-Macros$$ Need help on dynamic list

2010-12-08 Thread sharath sambrani
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 belon

Re: $$Excel-Macros$$ Need help on dynamic list

2010-12-08 Thread Deepak Rai
Hi, Please find the attached solution. In sheet one I have two validation lists, which is taking data from Sheet2. Sheet2 has named ranges. Hope this will help you. With the help of Named Range and Indirect formula you can do this very easily. Regards, Deepak Rai On Wed, Dec 8, 2010 at 7:33 PM