Hello,
I think VBA is what I need to solve this problem but want to see if I’m going down the right path before I start as I don’t know VBA at all and will have to start reading some books.
The sheet “August Lint Results” records how many pieces of lint were found on the floor of that dealership on that day.
The sheet “Cleaners Activity” indicates if the cleaners cleaned that dealership that morning. (TRUE meaning they did clean the dealership, FALSE otherwise)
I need to determine if the cleaners are doing a good job by creating an average pieces of lint with cleaners and an average without. So in short I want to count the pieces of lint on TRUE days and the pieces of lint on FALSE days separately and report on the overall average. This will allow us to determine if we should keep using the cleaners.
I’ve asked some Excel gurus at work and nobody knows how to do this. I’m thinking this is a job for VBA but as I said earlier just want to see if I’m on the right path or is there a more obvious solution?
Thanks!
Grant
Bookmarks