Forum Discussion
Do not paste into cells that already contain data
I want to copy a range of data somewhere else in my sheet, but I do not want the values to overwrite any data that may be in any of the target cells. This is effectively treating what I have copied t...
Hi - I came across this whilst looking for a solution. I don't see how you can perform step 3 in your solution after selecting 'Values' in step 2. The dialog box is open and you have to paste. At what stage do you write the formula you provided?
In retrospect, I'm also a bit confused by the description of your project. Could you please explain it in more detail?
Step by step, what you're planning.
A file or photos might be helpful.
Thank you for your patience and understanding.