I'm trying to figure out a way to copy and paste values from a filtered column and paste on the same index, but different column. Thake a look bellow how it should work:
Original:
| row | Column A | Column B |
|---|---|---|
| 1 | abcd | |
| 4 | acdf | |
| 9 | gfac |
Run VBA:
| row | Column A | Column B |
|---|---|---|
| 1 | abcd | abcd |
| 4 | acdf | acdf |
| 9 | gfac | gfac |
I tried SpecialCells(xlCellTypeVisible) but I couldn't make it work, because I need to copy only one specific column and not the entire sheet... can anyone help me? THANK YOU!