• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I can't pasted the value on non adjacent cells

G

GN0001

Member
I have posted a question and I don't know If I need to enter this question in the continuation of that thread or I should start a new thread.

I did the VLookUp and I put the result in column F, I filtered on #N/A values and used another data set as a source. I got some values, now I want to copy and pasted these new result as value. I don't want to erase the old values. I only want to paste the new values without overwriting other values that are already existing. What should I do?

It doesn't allow me to paste the Value on the filtered column on non adjacent cells. it says:
The selection is not valid
There are several reasons
Copy and paste can't overlap unless they are the same size.
I appreciate your response.

What is the solution?
Please help me with this as this takes a lot of my time.
Regards,
GN0001
 
GN0001 said:
I have posted a question and I don't know If I need to enter this question in the continuation of that thread or I should start a new thread.
Click to expand...
Hi, GN0001!
If your new question (this topic) is directly related to another thread of if it's a continuation with slight variations of that original one, then you should go on in that thread so as to keep all the posts together making it easy to get the full info about the problem
If your new question is far very different from the first one or if even on the same files it refers to another issue then you should open/start a new one. Eventually you might post a link to the original one if you consider it proper.
Regards!
 
You must log in or register to reply here.
Back
Top