When you paste into a filtered range, the pasted data fills up both the visible
cells and the hidden cells.

I try to sort my data so that it's contiguous (based on some key???) and then
paste into that contiguous range. I don't even need to use the filtering. Then
if I need to, I'll resort the data back to its original order.

teach1 wrote:

Hi

I have a file that I filter. Having found the required records, is there a
way to copy one of the columns data into a new column but ensuring the data
gets copied into the same row as the filtered records.

Normally I highlight the column of data for the filtered records
Use GoTo visible cells only
Copy
Select first cell in next column
Paste

The data is pasted from that cell down but doesn't get copied into the
filtered record rows.

Hope this makes sense.

Help!!

--

Dave Peterson