I need help creating a certain type of drop-down menu in Microsoft Excel
for example, i want to make a sheet where everyone's name is in column A, their weight in column B, and their height in column C. If i selected someone's name in the drop down menu of Column A, i'd want their data and only their data to appear in B and C. If i pulled someone's weight in the drop down of Column B, i'd want everyone's data who was that weight to show up. If i pulled the drop down in Column C for a particular height, i'd want everyone's data who was that height to show up. I'm assuming i'll be putting all this data in another worksheet to source from. Help please. Thanks.
|