View Full Version : excel queryTable

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

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

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.

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