-
excel queryTable
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
-
Can you post an example..
-
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.
-