I have a filtered list. There's 500 visible cells and about 500 filtered out.

I need to copy most of the visible cells in col U to col V. But I cant do so properly.

For example rows 15 and 19 are visible and in between they're filtered out. If I highlight from 15-19 and copy and try pasting into col V I only get one value there rather than 2.

I dont think a picture will help much but attaching just in case.

Can someone advise?

Thanks!
Dan


Excel Filter.PNG