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.
