Paste TO visible cells only in a filtered cells only

[NSK-Mar]

I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks 

[#2]

How do i paste multiple values on visible cells on a filtered array in excel?

[#3]

It's already on the toolbar, under Home > Editing. You can also add the icon to your Quick Access Toolbar.

[#4]

This is the answer. Thank you! Added it to my Quick Access Toolbar for future reference.

[#5]

Alhamdulillaah.. thank you, your solution help me solve my problem with copy-paste in filtered view..

[#6]

Glad it helped :)

[#7]

@Ingeborg Hawighorst  Its not working

I am still unable to put data in visible cells only'

[#8]

Its not working. kindly guide through video

[#9]

@Sajad_Alam If you are having issues, try my earlier post on the first page. 

[#10]

If anyone still has problem with this, please check out this article:

excel-vba-easy-way-to-paste-to-visible-cells 

it shows you how to make copy-paste visible cells functionality available in any open workbook.