View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Can you sort the unfiltered data by some key that groups the rows you want
together?

Then you could paste and sort back to the original order.

There's nothing built into excel that does what you ask.

CCSMCA wrote:

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


--

Dave Peterson