People in the Newsgroup, where most of the questions are answered (and this
is not Excel Forum) can not see your attachment. But guessing what you
might have,
Look at Data=Filter=Autofilter

--
Regards,
Tom Ogilvy

"angelrain" wrote in message
...

how do i display a list of data that is within a data
range?? i have a cell where user is able to enter an amount...say $100.
this will enable the data which is the names of hotels, its rates with
the input by user and the location of the hotels to be displayed...how
do i go about doing it???

PS: attached is a screen shot of the excel worksheet....


+-------------------------------------------------------------------+
|Filename: hotel rates.zip |
|Download: http://www.excelforum.com/attachment.php?postid=2747 |
+-------------------------------------------------------------------+

--
angelrain
------------------------------------------------------------------------
angelrain's Profile:
http://www.excelforum.com/member.php...o&userid=15990
View this thread: http://www.excelforum.com/showthread...hreadid=274798