Pasting filter results to another sheet

[ceejay22]

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

[gyclone]

The destination sheet needs to be active.

Please Login or Register  to view this content.

[ceejay22]

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

Any other suggestions to overcome this problem?

[gyclone]

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.

[ceejay22]

Worked a charm!

Thanks heaps