Thread: Extracting data from other worksheets using parameters

Hi,

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.

I suggest you take a look at using a Pivot Table and base its source on a dynamic named range.

Pivot Tables are very powerful and flexible and allow different views of the data almost instantly (well, with a few clicks anyway).

You can also create a Pivot Chart and quickly change which series get plotted.

See attached.