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
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
