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