I have a spreadsheet with currently 2 sheet. I'm trying to create a dropdown list of memebers in a group. I have about 20 groups with different members attached. I get to the point where I go to Data Validation source. I want my members on a seperate sheet and the dropdown to reflect the members in a column on that second sheet. I can't figure out how to define. It doesn't allow you to point to that sheet? I'm sure there's a formula but how do you define a range on a 3rd spreadsheet??