Filter out rows based on the value of a cell

[magmike]

Using Windows XP and Excel 2007

Would like to create a search box of sorts, where when I type a word
into a specific cell, let's say B2, then the rows displayed filter out
based on what I typed, so that only rows where column D equaled
"Smith" for example, would show. It would also be helpful if I could
select a value from a dropdown next to it determining which column
would be checked for the filtering. For example, I type "Smith" in
cell B2, and then select "Last Name" from the drop down so that the
rows displayed are filtered by showing only rows where the D column
(LastName) equals or contains "Smith".

My super-elite wish here, is that the filtering would update every
time a character was typed while still in the cell.

Is any of this possible?

Thanks in advance,

magmike

 

[James Ravenswood]

Using Windows XP and Excel 2007

Would like to create a search box of sorts, where when I type a word
into a specific cell, let's say B2, then the rows displayed filter out
based on what I typed, so that only rows where column D equaled
"Smith" for example, would show. It would also be helpful if I could
select a value from a dropdown next to it determining which column
would be checked for the filtering. For example, I type "Smith" in
cell B2, and then select "Last Name" from the drop down so that the
rows displayed are filtered by showing only rows where the D column
(LastName) equals or contains "Smith".

My super-elite wish here, is that the filtering would update every
time a character was typed while still in the cell.

Is any of this possible?

Thanks in advance,

magmike

90% of what you want is natively supported in Excel thru AutoFilter.
Once you have established the filter, all you need to do is click on
the Last Name column header cell and pick "Smith" from the drop-down
list. I suggest you check-out:

http://www.contextures.com/xlautofilter01_2003.html

 

[magmike]

90% of what you want is natively supported in Excel thru AutoFilter.
Once you have established the filter, all you need to do is click on
the Last Name column header cell and pick "Smith" from the drop-down
list.  I suggest you check-out:

http://www.contextures.com/xlautofilter01_2003.html- Hide quoted text -

- Show quoted text -

I am aware of Auto Filter and do use it. However this option would be
simpler to use in my instance, as tens of thousands of rows produce
quite the list to scroll through. I also know that you can also filter
by text, but the method I am trying to acheive would be a little bit
faster and simpler to use.

I was hoping there was a way to cause the sheet (through VB) to filter
out rows that did not contain the text of B2 once the cell was updated
or left.

Is this possible?

Mike

 

[magmike]

I am aware of Auto Filter and do use it. However this option would be
simpler to use in my instance, as tens of thousands of rows produce
quite the list to scroll through. I also know that you can also filter
by text, but the method I am trying to acheive would be a little bit
faster and simpler to use.

I was hoping there was a way to cause the sheet (through VB) to filter
out rows that did not contain the text of B2 once the cell was updated
or left.

Is this possible?

Mike- Hide quoted text -

- Show quoted text -

I found a solution to this that is really super-cool at
http://www.contextures.com/excelfiles.html#filters using the one
called Fast Filters.

magmike

 

[magmike]

Actually the link is http://www.contextures.com/excelfiles.html#filter
(I had an "s" on the end of the other which is incorrect)

magmike