On one sheet I have a column that uses "list of items" data validation which allows for a drop-down menu to extend and a multiple of options to be selected.
Is there a way to automatically populate the same relative column in sheet two with the items selected in the column in sheet 1?
For example, if "Dogs" is selected in Sheet1 A1, then it would automatically populate Sheet2 A1 with "Dogs".