Copy/paste data across filtered rows

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?
 
P

Peo Sjoblom

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

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top