how many different values are there that you want to filter.

it is not to long just copy the copy the amount of times and then you
should be able to paste it in different workbooks or sheets.

I think a "Do Loop" is in needed however I am not sure how to do a loop
with autofilter.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=516151