ExcelVBA (Search/Filter/Copy)
 

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

ExcelVBA (Search/Filter/Copy)
 

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

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.

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


In addition, I think my requirements is slightly different. If the same
customer has two or more entries, then I need to check under this customer.
Let say I want only Item A provided there is no Item B
Something like:

IF this customer has Item A in Column X THEN
IF this customer also has Item B in Column Y THEN
Ignore Customer
ELSE
Shortlist Customer
ELSe
Ignore Customer

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


To make it simple, let say I have this record:
111 Apple NewYork
111 Banana NewYork
222 Apple NewYork
222 Banana NewYork
222 Orange NewYork
333 Apple NewYork
555 Banana NewYork
555 Orange NewYork
666 Apple NewYork
777 Orange NewYork
777 Apple NewYork

The output I want is:

111 Apple NewYork
333 Apple NewYork
666 Apple NewYork


Note: For Apple in Customer 222 and 777 are NOT selected because this
customer has ORANGE

So, what is the suitable coding to search through multiple rows for same
customer , and do filtering there based on same customer number ?

Thanks.

Regards, Magix

ExcelVBA (Search/Filter/Copy)
 

Did you try the extra column and Ron's easyfilter?

If you did and it failed, post back with your questions.

magix wrote:

"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

To make it simple, let say I have this record:
111 Apple NewYork
111 Banana NewYork
222 Apple NewYork
222 Banana NewYork
222 Orange NewYork
333 Apple NewYork
555 Banana NewYork
555 Orange NewYork
666 Apple NewYork
777 Orange NewYork
777 Apple NewYork

The output I want is:

111 Apple NewYork
333 Apple NewYork
666 Apple NewYork

Note: For Apple in Customer 222 and 777 are NOT selected because this
customer has ORANGE

So, what is the suitable coding to search through multiple rows for same
customer , and do filtering there based on same customer number ?

Thanks.

Regards, Magix

--

Dave Peterson

ExcelVBA (Search/Filter/Copy)
 

The extra column and Ron's filter will not help. For my case, I need to
search those entries under same customer, and do the filtering.

The result will be copy to a new work sheet.

Please help.

"Dave Peterson" wrote in message
...
Did you try the extra column and Ron's easyfilter?

If you did and it failed, post back with your questions.

magix wrote:

"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

To make it simple, let say I have this record:
111 Apple NewYork
111 Banana NewYork
222 Apple NewYork
222 Banana NewYork
222 Orange NewYork
333 Apple NewYork
555 Banana NewYork
555 Orange NewYork
666 Apple NewYork
777 Orange NewYork
777 Apple NewYork

The output I want is:

111 Apple NewYork
333 Apple NewYork
666 Apple NewYork

Note: For Apple in Customer 222 and 777 are NOT selected because this
customer has ORANGE

So, what is the suitable coding to search through multiple rows for same
customer , and do filtering there based on same customer number ?

Thanks.

Regards, Magix

--

Dave Peterson

ExcelVBA (Search/Filter/Copy)
 

Since you have multiple threads in multiple newsgroups going on, I'll drop out.

magix wrote:

The extra column and Ron's filter will not help. For my case, I need to
search those entries under same customer, and do the filtering.

The result will be copy to a new work sheet.

Please help.

"Dave Peterson" wrote in message
...
Did you try the extra column and Ron's easyfilter?

If you did and it failed, post back with your questions.

magix wrote:

"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

To make it simple, let say I have this record:
111 Apple NewYork
111 Banana NewYork
222 Apple NewYork
222 Banana NewYork
222 Orange NewYork
333 Apple NewYork
555 Banana NewYork
555 Orange NewYork
666 Apple NewYork
777 Orange NewYork
777 Apple NewYork

The output I want is:

111 Apple NewYork
333 Apple NewYork
666 Apple NewYork

Note: For Apple in Customer 222 and 777 are NOT selected because this
customer has ORANGE

So, what is the suitable coding to search through multiple rows for same
customer , and do filtering there based on same customer number ?

Thanks.

Regards, Magix

--

Dave Peterson

--

Dave Peterson