Need help with Excel Sheet Name Referencing

%3CLINGO-SUB%20id%3D%22lingo-sub-3352976%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Excel%20Sheet%20Name%20Referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352976%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20Microsoft%20Excel%20for%20employee%20scheduling.%20I%20have%20over%2030%20locations%20that%20I%20have%20employees%20staffed%20each%20week.%20In%20my%20workbook%2C%20each%20specific%20location%20has%20its%20own%20worksheet.%20Some%20employees%20work%20multiple%20locations%20each%20week%2C%20so%20they%20have%20hours%20on%20multiple%20sheets.%20If%20I%20have%20employee%20(John%20Doe)%20scheduled%20for%208%20hours%20at%204%20locations%2C%20and%20I%20have%208%20in%20cell%20C16%20on%204%20different%20sheets%2C%20representing%208%20hours%2C%20but%20all%20the%20other%20sheets%20have%20nothing%20in%20cell%20C16.%20Is%20there%20a%20way%20to%20get%20excel%20to%20tell%20me%20which%20sheets%20have%20a%20number%20in%20cell%20C16%3F%20I%20don't%20need%20the%20totals%20from%20all%20the%20sheets%2C%20I%20just%20want%20the%20sheet%20names%20that%20have%20a%20number%20in%20cell%20C16.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3352976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I use Microsoft Excel for employee scheduling. I have over 30 locations that I have employees staffed each week. In my workbook, each specific location has its own worksheet. Some employees work multiple locations each week, so they have hours on multiple sheets. If I have employee (John Doe) scheduled for 8 hours at 4 locations, and I have 8 in cell C16 on 4 different sheets, representing 8 hours, but all the other sheets have nothing in cell C16. Is there a way to get excel to tell me which sheets have a number in cell C16? I don't need the totals from all the sheets, I just want the sheet names that have a number in cell C16.

0 Replies