View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
magix
 
Posts: n/a
Default ExcelVBA (Search/Filter/Copy)


"Dave Peterson" wrote in message
...
You have a suggestion at your other post in .excel

magix wrote:

Hi

I would like to do search, and filter and copy the necessary one into

new
worksheet
Please see attached excel file (Sample.xls) for sample data

Column A is Customer Number
Column B is Fruits
Column C is City

I want only those Apple from New York with one condition. If the

Customer
also has Orange from New York, then the customer will not be selected.

From the sample data, the output in new worksheet will be

333 Apple New York
555 Apple New York
888 Apple New York

Thank you.

Regards,
Magix

Name: sample.xls
sample.xls Type: Microsoft Excel Worksheet

(application/vnd.ms-excel)
Encoding: x-uuencode


--

Dave Peterson


Thanks, but I will appreciate a short coding to do what I mentioned above.