View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jln via OfficeKB.com jln via OfficeKB.com is offline
external usenet poster
 
Posts: 88
Default Filter then paste

I need to create a Macro that will work with named worksheets that works
with an that is lloks like this AutoFilter Field:=24, Criteria1:="0",
Operator:=xlAnd

I need the macro to select all the data that meets the above Criteria and
paste it into a sheet named NetPILIQ . The NetPILIQ Sheet dosesnt start until
row 6. after the data has been pasted i need a total placed at the bottom.

Please Help Im now where close with this.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200609/1