I have two spreadsheets, the first sheet has a list of data:


company A  
company B  
company C 

In the second sheet I need to create a drop down menu to fetch the companies from the first sheet, so I could choose the company from a list of the previous companies.


1 Answer 1


use the Importrange() command to put a copy of the data into a helper-sheet in the 2nd google Sheets file.

And then use the Data Validation function to restrict the values, based on this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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