Drop down menus and workbook sharing

Copper Contributor

So this is a shot in the dark.  I am trying to see if it is possible to create a drop down menu but have it pull data from another worksheet.  I am trying to create a way to easily select different options and have it displayed.  I would have 10 selections in the drop down menu and it would be able to display numbers.  Thank you.

1 Reply
You could use Data, Data Validation for that purpose.