Advanced Filtering

[jono7gold]

Hi,

I have two questions/dilemas regarding Advanced Filtering that I'm hoping someone can help me with?

1. is it possible for the results of the filter to be displayed in a table? I have tried to use table headers where the results are filtered to but this doesn't seem to work - the filters disapear from the table headers?

2. is it possible for the criteria range to search across move than one column - for example if I had a table with 6 headers could I search all 6 headers(columns) instead of just one column?

Many thanks

Jon

[Fotis1991]

1) http://exceluser.com/blog/1188/how-t...el-tables.html

2)Generally speaking..YES.