Paste to Visible Cells only

[Sandy Burgess]

Is there anyway to paste to visible cells only?

I know you can use Edit>Go to>Special>Visible Cells only to copy visible
cells but I need to paste to only the visible cells.

 

[Dave Peterson]

I try to sort the data to make the visible cells contiguous.