Copy/paste data across filtered rows

  • Thread starter Thread starter jday
  • Start date Start date
J

jday

I have a worksheet that contains an autofilter across columns A-E. If a user
filters column B, for example, they may decide to enter a value in one of
cells, then copy/paste that value across all of the "filtered" rows. The
issue is that when you remove the filter, all of the rows in between (that
had been 'filtered out') also have the pasted value. I can't figure out why
this is happening or how to correct. Any insights?
 
While you can copy non contiguous rows/columns you cannot paste into non
contiguous rows/columns

--


Regards,


Peo Sjoblom
 
Back
Top