software

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?

Hi imills

Do you want to do this
www.rondebruin.nl/copy5.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;imillsquot; gt; wrote in message ...
gt;I have a summary page of planting events. In the left column I have the feild
gt; name and the other other column have more info such as, date, seeding rate,
gt; variety, etc. I want to send the information to a summary sheet for each
gt; field. I have been able to advance filter the list for one specific field so
gt; far, and I have also created a Macro (Manually, I don't understand code) to
gt; execute the advance filter any time I want. The problem is I have over 50
gt; fields, and to build a macro that does all fields at once will take a lot of
gt; time and leave alot of room for error. I want to do the same thing for
gt; several more lists; planting, fertilizing, harvesting, irrigation, etc.
gt; Is there a faster way, such as advance filtering to multiple locations at
gt; 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.

quot;Ron de Bruinquot; wrote:

gt; Hi imills
gt;
gt; Do you want to do this
gt; www.rondebruin.nl/copy5.htm
gt;
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;imillsquot; gt; wrote in message ...
gt; gt;I have a summary page of planting events. In the left column I have the feild
gt; gt; name and the other other column have more info such as, date, seeding rate,
gt; gt; variety, etc. I want to send the information to a summary sheet for each
gt; gt; field. I have been able to advance filter the list for one specific field so
gt; gt; far, and I have also created a Macro (Manually, I don't understand code) to
gt; gt; execute the advance filter any time I want. The problem is I have over 50
gt; gt; fields, and to build a macro that does all fields at once will take a lot of
gt; gt; time and leave alot of room for error. I want to do the same thing for
gt; gt; several more lists; planting, fertilizing, harvesting, irrigation, etc.
gt; gt; Is there a faster way, such as advance filtering to multiple locations at
gt; gt; once?
gt;
gt;
gt;

Hi imills

gt; 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
www.rondebruin.nlquot;imillsquot; gt; wrote in message ...
gt; Yes Ron, I'm pretty sure this is what I want to do. But how do I do it?
gt; I don't understand VBA at at all.
gt; Thanks Ron.
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi imills
gt;gt;
gt;gt; Do you want to do this
gt;gt; www.rondebruin.nl/copy5.htm
gt;gt;
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;imillsquot; gt; wrote in message ...
gt;gt; gt;I have a summary page of planting events. In the left column I have the feild
gt;gt; gt; name and the other other column have more info such as, date, seeding rate,
gt;gt; gt; variety, etc. I want to send the information to a summary sheet for each
gt;gt; gt; field. I have been able to advance filter the list for one specific field so
gt;gt; gt; far, and I have also created a Macro (Manually, I don't understand code) to
gt;gt; gt; execute the advance filter any time I want. The problem is I have over 50
gt;gt; gt; fields, and to build a macro that does all fields at once will take a lot of
gt;gt; gt; time and leave alot of room for error. I want to do the same thing for
gt;gt; gt; several more lists; planting, fertilizing, harvesting, irrigation, etc.
gt;gt; gt; Is there a faster way, such as advance filtering to multiple locations at
gt;gt; gt; once?
gt;gt;
gt;gt;
gt;gt;