Pasting filter results to another sheet

Hi,

I am trying to filter reason for "SHO" and then copy and paste this to a new tab. I have the following code

Please Login or Register  to view this content.

The error i receive is "the copy and paste area are not the same size" so i tried selecting a specific cell and it still has the same error
Any help would be appreciated

Thanks

The destination sheet needs to be active.

Please Login or Register  to view this content.

I still get the same response. that the copy and paste areas are not the same size.

Any other suggestions to overcome this problem?

Sorry, late in the day. The error is because the source data is filtered. Activate a single cell on the destination before you paste.

Please Login or Register  to view this content.

Worked a charm!

Thanks heaps