hi bpotter

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

--

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


"bpotter" wrote in message ...
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.