View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default transferring data


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.