The attached workbook has a worksheet named "Info". We need to look up the Agent on this worksheet, column A, on the DATA worksheet and return:
1. Errors by agent in DATA/A1:A21 to Info/L2:L9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
2. Coaching by agent in DATA/A25:A33 to Info/N2:N9, (highlighted in red), without losing the data if someone sorts by agent or any data in either chart.
*if possible, we would like all charts to sort from smallest to largest automatically.
NOTE: Information is entered into the "RAW DATA" worksheet and pulled into the "DATA" worksheet. From there the "CHART" and "Info" worksheets pull info from the "DATA" worksheet.