View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Secret Squirrel Secret Squirrel is offline
external usenet poster
 
Posts: 172
Default Copy filtered data

I have a worksheet that I want to be able to cut and paste into a new file.
But I only want to be able to cut and paste the filtered rows. How would I go
about creating this macro/vba code to cut and paste only the rows that are
filtered and create a new file with just these rows?