Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display data of input that is within a data range???
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why input range contains non-numeric data? | Excel Discussion (Misc queries) | |||
extract data from a range based on other cell's input | Excel Discussion (Misc queries) | |||
specify a range of cells for data input, down then over | Excel Discussion (Misc queries) | |||
How can I run a spreasheet over range of input data ? | Excel Discussion (Misc queries) | |||
How can I set a input range for entrying data. | Excel Worksheet Functions |