A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Now, let’s create a dropdown on another sheet named Dropdown and reference Animals_List : Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet).

Learn how to build a powerful business dashboard for your Facebook Ads in Google Data Studio in 9 easy steps.