Hi,
I would like to copy information from another sheet to drop-down menu in another sheet. It seems that I cannot choose source from another sheet and reference it in any way.
If possible the copying could be dynamic/automatic, so that when there is additions to the source, drop-down menu is updated also.
Thanks in advance.
I would like to copy information from another sheet to drop-down menu in another sheet. It seems that I cannot choose source from another sheet and reference it in any way.
If possible the copying could be dynamic/automatic, so that when there is additions to the source, drop-down menu is updated also.
Thanks in advance.