Copy and Paste Filtered Cells in Excel 2007

G

Gillian

I have filtered a large list and want to copy the contents of the cells
containing the filtered criteria into the adjacent column so that I can
correct them whilst leaving the original data intact. I know how to 'go to'
- 'visible cells only' and then copy, but when I paste the data it is not
pasting into the filtered rows. For example, my filtered row numbers run
from 408, 1608, 1711, 2069 and there are about 300 records that meet the
filter criteria. When I paste the records, they are simply being pasted into
row 408 - 708. Thanks, hopefully.
Gillian
 

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

Copy and paste area not same in filtered mode . 8
copy and paste filtered cells 1
Copy and Paste Format in filtered rows 6
Copy/Paste (Clipboard) Issues 1
paste data next to filtered values 1
Copy and pasting values of filtered rows 1
Filter, Copy and Paste 2
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6

Top