I am wanting to autofilter a certain column, pull out all searsh
criteria and then create sheets built off of this critieria. Then I am
wanting to copy and paste each autofilter to the right sheet.
I have looked through the autofilter loop and found some good ideas
but none of them seam to work for me.
I am really hitting a brick wall on this. Please Help.

hi bpotter

See this page
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"bpotter" <(E-Mail Removed)> wrote in message news:de17e2a5-b3b1-4ee8-8b31-(E-Mail Removed)...
>I am wanting to autofilter a certain column, pull out all searsh
> criteria and then create sheets built off of this critieria. Then I am
> wanting to copy and paste each autofilter to the right sheet.
> I have looked through the autofilter loop and found some good ideas
> but none of them seam to work for me.
> I am really hitting a brick wall on this. Please Help.