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!!