I am trying to create an Excel tool to manage salespeople's daily activities (tasks). We are actually using a CRM system to manage their tasks, but unfortunately it is still under development and does not have any reporting features (so salespeople are inputting their daily tasks but there is no way for managers to see the overall data on the screen). So the idea of this tool is to copy/paste the downloadable raw data and show various reports.
I have most of the tool completed, most importantly the "Dashboard" sheet where it allows shows the number of tasks completed and the purpose of those tasks in the previous week, and also tasks scheduled for next week. It also includes the monthly cumulative data. This sheet is linked to "Tasks by Salesperson" and "Purposes by Salesperson", where it extracts and counts from the Raw Data.
I have having EXTREME difficulty working on "Completed Task Summary" sheet. Basically, I want to show all the details of the tasks completed by the particular salesperson during the previous week. The name of the salesperson is in C3, the week start/end is in G3 and G4. All I need to do is show the details (Customer Name, Action taken, Purpose of the action, date scheduled / completed, and comments) of each task completed by the selected salesperson and compelted between those dates. The raw data is found in "RawData" sheet.
I've been playing around with combinations of VLOOKUP, INDEX, MATCH, LARGE, SMALL, etc... but I've had no luck. I would appreciate any suggestion or help on this.
P.S. the Raw Data is in Korean, but this tool will be used across the world and therefore should be made so that the language of the raw data does not matter (or is controllable, as I did in "Master Setting" sheet).