Query Data Look up

dantb · Apr 2nd, 2002, 02:04 PM

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.

Mark W. · Apr 2nd, 2002, 02:08 PM

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 ]

dantb · Apr 2nd, 2002, 02:11 PM

Ok thx Mark. Have a good day !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 02:04 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	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.

Apr 2nd, 2002, 02:08 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Apr 2nd, 2002, 02:11 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Ok thx Mark. Have a good day !