Generate Report with selection.

**hecgroups** · 01-21-2012, 11:07 AM

Hello,

I am asking help again.

1. If i select one selection from first datavalidation. Based on that selection the second datavalidation provide the list. i have done this with the help of using indirect but only TYPE is not working.
2. If i select the option from second datavalidation list it should list the details.

Example: If i select CCHI First data validation) then the second data validation should be Expired or Valid. From these options if i select valid, it should list entire row on below space.

Copy of file is attached for your reference.

Your rapid response is highly appreciable.

**_lh** · 01-21-2012, 12:04 PM

The named range "Type" is referring to an invalid location (returning a #REF error) most likely as it is somewhere in a linked workbook. Delete this named range and recreate it with a reference to the correct location, in this case: 'Data List'!$B$2:$B$5 and you should find that it works again.