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

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