I suggest you review the basics for creating dependant dropdown lists here...
https://www.contextures.com/xlDataVal02.html
...then read the Google Sheets user guide for DataValidation basics. The key is
in how you define the named ranges containing your lists and so between these 2
suggested actions you should be able to *figure it out* so you can share it
with others using Google Sheets.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion