Paste to visible cells only

[lichfields]

I'm trying to copy data from column A in a filtered list to the next column B. As column B is of course also filtered, I want to copy the visible cells (no problem) but then paste them to the visible cells (problem).

I've checked through earlier questions on this subject to find an answer but it seems there isn't one - at least not a straightforward one.

I did find a possible solution in the form of a "Code" as follows:

Worksheets("Sheet Name").Activate
Range("A2").Select
Selection.Copy
Range("A3:N1000").Select
ActiveSheet.Paste
Application.CutCopyMode = False

Is this a macro thing? If so, how do you use it? I'm afraid I'm a macro virgin

Can anyone help?

 

[hhok777777]

I uploaded EXCEL ADDIN solution to github repository below:
https://github.com/hhokawa777/excel_addin-copy_and_paste_visible_cells_only

This was an experiment years ago after reading over this thread and others that time.
Originally Japanese UI version only for personal use, today I made English UI version as open source work.
But haven't confirmed this works in different language environment or not.

Main part of VBA code:
https://github.com/hhokawa777/excel...eToVisibleCellsOnly.xlam/CopyPasteVisible.bas

UI image: