About

I have an existing Google sheet that has a number of "divisions" where names are dynamically loaded in a drop down menu from helper sheets Some of the sheets are "paired" in that they load the drop down options from a shared list, and once an option is selected from the available drop down options, it is not longer available to be selected (from the same sheet or the paired one that is shares with) I needed to clone on single sheet to set it up with a pair - they are functioning but they the available list from the drop down is not removing already selected values from the list of available options