PDA

View Full Version : excel queryTable



ltworf13
11-09-2007, 10:19 AM
Never used QueryTables before need help. I have 1 workbook with to sheets.
A datasheet and a reportsheet. the datasheet has field names:
Dept, Location, Skill, Calls Offered, & BAHT.

So lets say in the reportsheet on Cell A1 I need a specific Dept,Location summary from teh datasheet. How do I use QueryTables to get the data.

BTW the calculation I would need is Sum(Calls Offered *BAHT)/sum(Calls Offered) in the select query

Nurofen
11-09-2007, 03:44 PM
Can you post an example..

XLGibbs
11-09-2007, 04:09 PM
Data>External Data>Database Query

Point to your excel file and look for the name of your query table or sheet in the list of available tables (named ranges will show up, so will sheet names).

Follow the wizard and write a query to your excel file as if it were a database. I have done this many times.

ltworf13
11-12-2007, 09:14 AM
thx much that worked