how to display data of input that is within a data range???
 

:confused: how do i display a list of data that is within a dat
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 wit
the input by user and the location of the hotels to be displayed...ho
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
+-------------------------------------------------------------------

--
angelrai
-----------------------------------------------------------------------
angelrain's Profile: http://www.excelforum.com/member.php...fo&userid=1599
View this thread: http://www.excelforum.com/showthread.php?threadid=27479

how to display data of input that is within a data range???
 

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
...

:confused: 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