how to display data within the given range of data input by user???

[angelrain]

i have a column of hotel names(E7:E38), another column of hotel rate
(G7:G38)and another column of hotel location(H7:H38). how is it suc
that when a user input say $100 in a cell F40, it displays th
information of hotels within the hotel rates of $100. how to displa
the all information below the cell F40?? :

 

[Jim Rech]

There is no feature in Excel that will instantly create a table of matches
from your list. You could use Data, Filter, Advanced filter to get the
output you want or, of course, you could write a macro that creates the
list.

--
Jim Rech
Excel MVP
|
| i have a column of hotel names(E7:E38), another column of hotel rates
| (G7:G38)and another column of hotel location(H7:H38). how is it such
| that when a user input say $100 in a cell F40, it displays the
| information of hotels within the hotel rates of $100. how to display
| the all information below the cell F40??
|
|
| --
| angelrain
| ------------------------------------------------------------------------
| angelrain's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=15990
| View this thread: http://www.excelforum.com/showthread.php?threadid=274816
|