I need an excel expert
Budget: $30 – $250 CAD
I need help with a corporate reporting project. Our team in the field works at 200+ job sites. They are required to complete a daily report at each site through an online reporting system called Tracktik. We want to create a monthly report that shows completion % by jobsite. So we would pull a report from Tracktik that would show a total list of completed reports. Then normally we would do a v-lookup against our list of active sites to show that one was done. However, the nuance here is that we want it to show that a report was done for each site for each day of the month, which a v-lookup won't tell us, as far as I'm aware. This is where we need some help...