Forum Discussion

Tony2021

Steel Contributor

Nov 10, 2022

Solved

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 t...

excel

Patrick2788
Nov 10, 2022
Tony2021

Flash Fill. In the gif, I use the menu command, but you could also do the shortcut ctrl+e.

Cangkir

Copper Contributor

Nov 11, 2022

Tony2021

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

Tony2021
Steel Contributor
Nov 11, 2022
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.
- Cangkir
  Copper Contributor
  Nov 11, 2022
  You're welcome, glad it work.