Pasting into Visible cell range only - VBA?

[Rellsunn]

Hi!

Trying to figure out how to take consecutive data from one tab and paste it into visible cells only on another report. My Kutools trial is over and I used to be able to do so by using Paste to visible Range.

Basically I need consecutive data to paste into every 4th cell but right now it's taking the first row of data and repeating it until the end of my range in which the balance of the rows is then pasted consecutively.

I've tried copying and then choosing Find & Select - Go to Special - Visible Cells only then pasting and no luck as it does what I mentioned above.

Help! Thanks