Macro for Search

**mpfoust** · 10-20-2010, 03:31 PM

Hello,

I am in need of a macro and user panel to search my excel database and display the entire row of data. I need to be able to find a range of data from whatever column is selected. Please help. I am not familiar with macros. Thanks.

**JBeaucaire** · 10-20-2010, 04:01 PM

...and we're not familiar with your workbook, your search needs, the layout of the data nor the desired layout of the results of a "search" as you imagine it.

Mockup a sheet in you workbook to demonstrate what the final output should look like based on a sample search. Make sure your workbook includes a sheet with enough sample data to demonstrate where the "results" were culled from.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook and we'll take a look.

**mpfoust** · 10-20-2010, 04:36 PM

Thanks for responding. I included a diluted part of the database. Let me know if you need more information.

**JBeaucaire** · 10-20-2010, 05:10 PM

See, this is simpler than you described. Excel has an AutoFilter feature specifically designed to do what you want.

1) Click on row 1
2) Select Data > Filter > AutoFilter
3) Select the drop down in column R and do a custom filter for:

Greater than or equal to 400
...and...
Less than or equal to 600

**mpfoust** · 10-21-2010, 10:14 AM

That is what I would like to do, but I need to have a user friendly control for this. Is there a way to make a control panel that would do the same thing but without having to set up a custom filter every time?

And I do appreciate your help!!!!!

**MarvinP** · 10-21-2010, 10:29 AM

Hi mpfoust,
Autofilters are an extension of Advanced Filter. The user interface is a little different and with a little bit of code can extract the filtered data to another range. Perhaps Advanced Filters (instead of Auto Filter) is what you desire.
http://www.contextures.com/xladvfilter01.html
http://www.excelfunctions.net/ExcelAdvancedFilter.html

**JBeaucaire** · 10-21-2010, 11:07 AM

I added a couple of buttons at the top of your database sheet so you can simply enter your values and the data will be filtered by the column chosen and the values entered.