Hello All,
I am somewhat new to Excel and have been Tasked to create a Dashboard for the company I work at. I have done all of the basics and its a really good dashboard but they want me to include an area where you can see the employees Picking Efficiency and Receiving Efficiency. The way its calculated would be (Total number of lines/Number of hours worked) Example: 178/7= 25.428 Lines per hour. Everyday a report is generated like the one I am sharing that is placed into an existing Pivot Table.
My problem is I'm not sure how to automate this task so the employer can just search "Employee A" somewhere on the dashboard and see their Picking Efficiency for that given day. Does anyone know how I can set this up? In the File I've attached columns A, B and F is the data I'll be using.
Open to all suggestions/opinions. Sorry if message is vague, ask if you need additional info. Thanks!
Also, the data report is given to me through Excel 97-2003 to which I input into what I believe is Excel 2015
Bookmarks