data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-2792908%22%20slang%3D%22en-US%22%3Edata%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792908%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20a%20workbook%20for%20recording%20tips%20for%20my%20staff.%20Presently%2C%20I%20have%20a%20summary%20sheet%20which%20gets%20the%20data%20from%20the%20days%20of%20the%20week.%20I%20would%20like%20to%20make%20the%20daily%20sheets%20easier%20to%20read%20by%20reducing%20their%20size.%20Right%20now%20the%20names%20are%20in%20alphabetical%20order%2C%20but%20I%20would%20rather%20use%20a%20drop%20down%20menu%20of%20names%20for%20each%20position%2C%20and%20then%20have%20the%20data%20report%20to%20the%20appropriate%20name%20on%20the%20summary%20sheet.%20I%20could%20use%20some%20help%20figuring%20out%20to%20accomplish%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2792908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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

@Chris1991 

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.