Aug 18 2021 08:18 AM
I have a spreadsheet made for each of my technicians, with the data validation list and it's populating correctly except I'd like one more item in the list for "All" technicians, meaning the formula to calculate all of the criteria set within all of the names listed. I'm just not sure how to do that. Any suggestions would be amazing!
Data needed is under the Month Tab.
Aug 18 2021 08:45 AM
@sawaccounting I would scrap all the individual sheets and collect all employee information in on schedule. Then use pivot tables to create the summaries you described. No need for all those complicated formulae the just reduce overall performance. See attached.
Aug 18 2021 08:56 AM
Aug 18 2021 09:04 AM
@sawaccounting Your sheet is terribly slow and overly complicated in my opinion. How difficult can it be to teach an average user to press a filter button in a pivot table that selects one individual or all? It's almost as easy as explaining that they have to chose another sheet. Your choice.