Thread: multiple search criteria to find and copy from sheet1 and paste into sheet2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
lothario[_55_] lothario[_55_] is offline
external usenet poster
  
Posts: 1
Default multiple search criteria to find and copy from sheet1 and paste into sheet2

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

Reply With QuoteReply With Quote