Forum Discussion
Pasting into only visible cells Excel
Hi, I want to paste a selection of multiple cells containing different numbers like A2 contains 83, A3 contains 55, A4 contains 14, etc. And I want to paste them in a column containing only zeros an...
If you're ok to use vba I can write a macro to do that.
It works like this:
Run the code > an inputbox will pop up > select the range to copy > OK > another inputbox will pop up > select the range to paste (select the first cell only) > OK
Let me know if you're interested in this method.