Forum Discussion
Paste TO visible cells only in a filtered cells only
I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks
NSK-Mar
Here's a video can solve this problem
https://youtu.be/F0pUKDQZ9RI
MMeligy Thanks for this post, however, the issue is with when columns are hidden. It is easier when dealing with row cells but difficult pasting to visible columns.
MMeligy use Index & Match instead https://www.excel-easy.com/examples/index-match.html
