Forum Discussion
Filtered List - Cant Copy from one column to another
Hello Experts, I have had this issue of not being able to copy data from one column to another if the list is filtered. I want to be able to copy the entire range and paste it into the same rows in the other column but excel doesnt allow it. I have to do it one by one and its time consuming.
Is there some trick to doing this?
thank you.
10 Replies
To copy-paste from visible cells to visible cells, try using “Sub CopyVisibleToVisible1” macro. You can put the macro in Personal.xlsb & assign the macro to a toolbar button, so you can use it on any open workbook.
You can find it here:
https://techcommunity.microsoft.com/t5/excel/paste-to-visible-cells-only-in-a-filtered-cells-only/m-p/3648053/highlight/true#M166604- Hi Cangkir, wow! that worked perfectly! Thank you so much for that code. I put it in the personal.xlsb. I am glad you mentioned the personal.xlsb since I forgot about it since I have it hidden on start and thought I would have to save my file as a macro enabled but I dont need to now. thanks again.
- You're welcome, glad it work.
ahh yes the flash fill. Awesome. Thank you very much.
- You're welcome! The only drawback to using Flash Fill is the columns have to be neighboring each other. In your example it works out.
