Query Data Look up
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Query Data Look up

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi all, What I have is a Workbook that has 3 automatic query's that start when the workbook is open. Each pulls in about 30000 records from 3 different dbase's.I would like to get rid of these start up query's. I was wondering if there was a way, To only have the records that I am looking for be retrieved. Each Record has a unique number like (101040). At the most on any worksheet is 300 numbers neaded, so I am pulling alot of data into the program that is not always neaded.
    So If the user types in ( 101040), and so on. Can only the specified records that the user types in,be imported into the worksheet.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help topics for "Create a query that prompts for criteria" and "Guidelines for constructing a query". Pay special attention to the 2nd topic's mention of a parameter query.

    [ This Message was edited by: Mark W. on 2002-04-02 13:12 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Ok thx Mark. Have a good day !

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com