1

I need to copy the data validation info from a column in Google Sheet (multiple cells in that column with data validation) to another Google Sheet. When doing the regular copy/paste or copy/paste Data Validation only, nothing is being "pasted".

Any idea/help would be appreciated.

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Jan 30 at 22:42
0

You cannot paste validation from one Google sheet to another.
Google Sheets does not currently have such a built-in solution.
On the other hand, when on the same sheet you can use the Paste special feature.

An alternative would be to pull your values from the other sheet for dynamic Data validation


paste data validation

In case you really need such functionality, you could do that using a script as mentioned here.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.