Mar 24 2022 05:27 AM - edited Mar 24 2022 05:28 AM
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 and blank cells. I want the paste to skip all the blank cells and override the zero's, but if I select only the cells with a zero I can't paste and get an error: "This action won't work on multiple selections".
Skipping blanks with special paste doesn't work either since it skips the blanks in the range that I am pasting and not the blanks in the range im pasting into.
Please help!
Mar 24 2022 06:05 AM
Excel does not support this. You'll have to sort the target column in such a way that the target cells form a contiguous range. You can then paste into that range. Finally, if necessary, restore the original sort order.
Mar 24 2022 06:29 AM
Mar 24 2022 06:41 AM
Je kan Microsoft een suggestie doen in Bestand > Feedback
Mar 26 2022 09:23 PM
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.