Querying data

[paulquinlan100]

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

 

[Dave F]

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