Indirect filter

[Luis Guembes]

I want to filter a data table usiong a criteria stored in a cell. I tried
indirect and some macros with no result in Excel 2007.

Thanks in advance for any light about this problem.

 

[Sheeloo]

You need to have at least two rows in the filter criterial... one having the
column heading and the other the condition... Once you have that then you can
use Advanced Filter on the Data tab...