filter your data. Select the data and press F5 and click on special and
select visible cells only and copy the data and paste it.

"Nikki" wrote:

highlight the selection--press F5 key--click special--select visible cells
only copy and paste...only visible rows get pasted...

"Tavo" wrote:

How do you paste filtered data and prevent hidden cells from receiveing
the data when you paste.