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

  • Thread starter Thread starter angelrain
  • Start date Start date
A

angelrain

: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
+-------------------------------------------------------------------
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add data Range property at runtime to excel sheet 1
how to display data within the given range of data input by user??? 1
CAN I MODIFY DATA ENTERED INTO A CELL 1
Automatically Increasing Chart Ranges 2
Creating a Macro Button to Extract Data 4
Formula that brings in daily input from a range of cells. 3
Interactive Data Entry 2
i want to input data into a range from a simple input location 1

Back
Top