data validation

Copper Contributor

I use a workbook for recording tips for my staff. Presently, I have a summary sheet which gets the data from the days of the week. I would like to make the daily sheets easier to read by reducing their size. Right now the names are in alphabetical order, but I would rather use a drop down menu of names for each position, and then have the data report to the appropriate name on the summary sheet. I could use some help figuring out to accomplish this.

1 Reply


It looks like you need dependent drop-down list (position->name). One of samples How to make dependent dropdown lists in Excel | Exceljet but you may find much more.