Debra Dalgleish has some code to copy filtered rows here...
http://www.contextures.on.ca/xlautofilter03.html
(Note: it won't work on xl97)
--
Jim Cone
Portland, Oregon USA
"Chad Portman"
wrote in message
I can not send the workbook to anyone for company reasons and the idea of
filter and copy paste does not work well cause something I forgot to mention
is the orginal list gets updated every 30 mins.