Filtered data - copy and paste in the same worksheet
In my Excel sheet, I have column R data which I filter.
After filtering, I wish to copy the visible data into the equivalent row in column AF.
After filtering, rows 29 and 263 are visible.
How do I copy data from cells R29 and R263 to AF29 and AF263 respectively without pasting anything in the non-visible AF cells.
The only way that works so far is to copy and paste each row separately.
This is not practical - there are too many rows.
Is there a solution without using VBA?