If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I'm hoping someone can help me with this. It sounds simple enough, but I'm very new to Excel.
I have attached a sample spreadsheet.
I want to be able to automate the reporting process as much as possible, so the user can enter the quarter (or range of work weeks) and process from either drop down menu or by entering data, and the data will automatically populate without having to manipulate the formulas: A dynamic report.
1.By quarter (work week range) for each process with a separate column for TAT and Quality showing the average for each - Need associated bar graph for TAT/Quality showing the average for each quarter.
2.All processes in current quarter: with average of each process and then the average of all process for the quarter - Need associated bar graphs for TAT/Quality
If someone can help me with the formula to pull the data from one worksheet containing the data and moving it to a report worksheet, I would really appreciate it. I can figure out how to do the averages.
Linear Mode
