Thread: filter data in one worksheet and copy into another

I have done this using Code. The basic premise I used was within a range if the rowIndex.Hidden was true then the item was filtered if false then copy elsewhere.

'Say for a worksheet that has a filter
With YourWorksheet
   For each rowIndex in .UsedRange.Rows
      If rowIndex.Hidden = False then
         'put your copy commands/logic here
      End If
   Next
End With

Hope this gets you started...