2 ways to create a Dropdown from another File in Google Sheets

In this tip, we will learn two ways to create a dropdown with data from another Google Sheets file.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@vivekkaushal8691]

Error
The data validation rule has more items than the limit of 500. Use the "List from a range" criteria instead.

[@practicalsheets]

You are right!
But, unfortunately, "List from a range" only accepts ranges present on a current file. It won´t work in this case
Kind Regards,

[@MarisaArnoldDLS]

If I convert the dropdown menu to the a google table, is there a way to automatically format the text background and font colors?

[@practicalsheets]

Hmmm
Right now, I wouldn't know how to, but will look into it
Kind Regards

[@MarisaArnoldDLS]

@@practicalsheets TY

[@plamenyankov8476]

Thanks a lot🫀! I think this was a super helpful tutorial👏!!

[@practicalsheets]

Thanks for the comments!

[@FuzzyDreamin]

Is there a way for dropdown menus to keep any hyperlinks attached to the aux text being used?

[@practicalsheets]

Unfortunately not in Sheets. Hopefully in the future
Kind Regards

[@sqgrowthconnect]

Is it possible to add a filter to this script? if so, can you demonstrate or share the amended script?