Hi Patrick,

I tried your suggestion in super_sheet.
In the AutoFilter dialogbox, I specified contains and =sub_sheet2!$B$3
This does not work. None of the rows are selected in super_sheet.
The =sub_sheet2!$B$3 reference does not work.
What am I doing wrong?

On the other hand when I specify contains and rro
I get the correct results because all the rows in that column tha
contain the text rro are displayed.

But I cannot use a hard value like rro.
I need to use the cell reference.
Please tell me how to correctly enter the =sub_sheet2!$B$3 cel
reference in the AutoFilter dialogbox.

Thanks.
Luthe

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com