Consulting

Results 1 to 4 of 4

Thread: excel queryTable

  1. #1
    VBAX Regular
    Joined
    Jun 2007
    Posts
    10
    Location

    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

  2. #2
    Can you post an example..

  3. #3
    VBAX Master XLGibbs's Avatar
    Joined
    Jan 2006
    Location
    state of confusion, but vacation in denial
    Posts
    1,315
    Location
    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.
    If you have posted the same question at multiple forums, please read this IMPORTANT INFO.

    Please use the thread tools to mark your thread Solved


    Please review the Knowledge Base
    for samples and solutions , or to submit your own!




  4. #4
    VBAX Regular
    Joined
    Jun 2007
    Posts
    10
    Location
    thx much that worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •