-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules