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