Welcome to the Excel Forum

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.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 06-25-2009, 08:47 PM
excel_neophyte excel_neophyte is offline
Registered User
 
Join Date: 25 Jun 2009
Location: CA
MS Office Version:Excel 2007
Posts: 1
excel_neophyte is becoming part of the community
Extracting data from other worksheets using parameters

Please Register to Remove these Ads

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.
Attached Files
File Type: xlsx sample.xlsx (19.4 KB, 10 views)
Reply With Quote
  #2  
Old 07-21-2009, 08:49 PM
Palmetto's Avatar
Palmetto Palmetto is offline
Forum Guru
 
Join Date: 04 Apr 2007
Location: South Carolina, USA
MS Office Version:XP, 2007
Posts: 2,170
Palmetto Has a higher level of understanding Palmetto Has a higher level of understanding Palmetto Has a higher level of understanding Palmetto Has a higher level of understanding Palmetto Has a higher level of understanding Palmetto Has a higher level of understanding
Re: Extracting data from other worksheets using parameters

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.
Attached Files
File Type: xls 689204-extracting-data.xls (60.5 KB, 6 views)
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump