| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
