Copy/paste data across filtered rows
 

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?

Copy/paste data across filtered rows
 

While you can copy non contiguous rows/columns you cannot paste into non
contiguous rows/columns

--


Regards,


Peo Sjoblom


"jday" wrote in message
...
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?