How to paste to visible columns only?

[wo1f]

This is my sample file.

Filter column A with `a` character

What I want to do is to copy content in D1:D3 and paste it in Column B.

However, when I paste it to column B, only B2 and B3 field were filled up with "aaa". It is supposed to be pasted to B5 as well, but it's not.

When I clear the filter, it turn's out that "aaa" were paste to invisible column as well including B4

What is the right way to paste into "Visible Column" only?

 

[Akuini]

Hi, wo1f
I don't know how to do that without macro.
So if you're interested I can share a macro that can copy-paste visible cells to visible cells.