VBA required to paste datas in to visible cells

How are you doing it manually?

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sir, Sorry for not uploading the sample excel before itself, i think for my last thread someone marked Negative reputation Hereafter i will attached the sample data for all threads.
(Actually i was working in virtual display so i m taking screenshots & markup ...thatz the reason.)

i follow the below mentioned STEPS to copy paste data in visible cells, but now i am getting error as per the screenshot.

STEPS:
copy the formula or value to the clipboard
select the filtered column
hit F5 or Ctrl+G to open the Go To dialog
Click Special
click "Visible cells only" and OK
hit Ctrl+V to paste.

To be more clear in explaining, i have exactly simillar issue as in below thread.
https://techcommunity.microsoft.com/...ht/true#M69925

You cannot copy contiguous cells and paste them into non-contiguous cells.