Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I advance filter to multiple locations at once?
I have a summary page of planting events. In the left column I have the feild
name and the other other column have more info such as, date, seeding rate, variety, etc. I want to send the information to a summary sheet for each field. I have been able to advance filter the list for one specific field so far, and I have also created a Macro (Manually, I don't understand code) to execute the advance filter any time I want. The problem is I have over 50 fields, and to build a macro that does all fields at once will take a lot of time and leave alot of room for error. I want to do the same thing for several more lists; planting, fertilizing, harvesting, irrigation, etc. Is there a faster way, such as advance filtering to multiple locations at once? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I advance filter to multiple locations at once?
Hi imills
Do you want to do this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "imills" wrote in message ... I have a summary page of planting events. In the left column I have the feild name and the other other column have more info such as, date, seeding rate, variety, etc. I want to send the information to a summary sheet for each field. I have been able to advance filter the list for one specific field so far, and I have also created a Macro (Manually, I don't understand code) to execute the advance filter any time I want. The problem is I have over 50 fields, and to build a macro that does all fields at once will take a lot of time and leave alot of room for error. I want to do the same thing for several more lists; planting, fertilizing, harvesting, irrigation, etc. Is there a faster way, such as advance filtering to multiple locations at once? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I advance filter to multiple locations at once?
Yes Ron, I'm pretty sure this is what I want to do. But how do I do it?
I don't understand VBA at at all. Thanks Ron. "Ron de Bruin" wrote: Hi imills Do you want to do this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "imills" wrote in message ... I have a summary page of planting events. In the left column I have the feild name and the other other column have more info such as, date, seeding rate, variety, etc. I want to send the information to a summary sheet for each field. I have been able to advance filter the list for one specific field so far, and I have also created a Macro (Manually, I don't understand code) to execute the advance filter any time I want. The problem is I have over 50 fields, and to build a macro that does all fields at once will take a lot of time and leave alot of room for error. I want to do the same thing for several more lists; planting, fertilizing, harvesting, irrigation, etc. Is there a faster way, such as advance filtering to multiple locations at once? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I advance filter to multiple locations at once?
Hi imills
I don't understand VBA at at all. Ok, Send me your test file private and I will help you Tell me exact what you want to do in the mail. -- Regards Ron de Bruin http://www.rondebruin.nl "imills" wrote in message ... Yes Ron, I'm pretty sure this is what I want to do. But how do I do it? I don't understand VBA at at all. Thanks Ron. "Ron de Bruin" wrote: Hi imills Do you want to do this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "imills" wrote in message ... I have a summary page of planting events. In the left column I have the feild name and the other other column have more info such as, date, seeding rate, variety, etc. I want to send the information to a summary sheet for each field. I have been able to advance filter the list for one specific field so far, and I have also created a Macro (Manually, I don't understand code) to execute the advance filter any time I want. The problem is I have over 50 fields, and to build a macro that does all fields at once will take a lot of time and leave alot of room for error. I want to do the same thing for several more lists; planting, fertilizing, harvesting, irrigation, etc. Is there a faster way, such as advance filtering to multiple locations at once? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter based value in multiple columns | Excel Discussion (Misc queries) | |||
How do I filter with multiple conditions in one field? | Excel Discussion (Misc queries) | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
FILTER ONE MULTIPLE SHEETS | Excel Worksheet Functions | |||
about advance filter | New Users to Excel |