Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Querying data
Hi
I have a spreadsheet that looks up to a seperate sheet of base data. I want the user to be able to type in a number on the front sheet, which then pulls out all records from the base table within 20% of that number. This is pretty easy to do in Access/SQL but is there a way of doing it in excel? Thanks for any suggestions. Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Querying data
One possibility: Data--External Data--New database query
The database in this instance would be your Excel table. You'll find this query tool somewhat similar to Access' GUI. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Hi I have a spreadsheet that looks up to a seperate sheet of base data. I want the user to be able to type in a number on the front sheet, which then pulls out all records from the base table within 20% of that number. This is pretty easy to do in Access/SQL but is there a way of doing it in excel? Thanks for any suggestions. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Querying Internal Data | Excel Discussion (Misc queries) | |||
Querying data in Business Contact Manager | Excel Discussion (Misc queries) | |||
QUERYING ACCESS | Excel Discussion (Misc queries) | |||
Querying data from Access | Excel Worksheet Functions | |||
Querying Data from Access | Excel Discussion (Misc queries) |