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

Similar Threads

Problem with Pasting into Filtered Fields 2
how do i print filtered rows in Excel? 1
Ratio of growth over a filtered set 3
Excel 2007 - copying filtered data to another workbook 1
Copy Paste filtered column ok in 2003 not in 2007 3
Referncing Rows of Filtered Data 8
Drag and fill on a filtered data sheet. 6
numbering rows in a filtered worksheet 3

Top