Search Button

Hi Guys,

I am new to this so please bear with me and if you have no clue as to what im trying to describe then please do say and I will try to elaborate.

Guys, im looking to add a search button to a specific sheet where by if users type text into a box next to it click a search button it will filter the data and display only what they have typed into the box.

any ideas? i've tried Visual Basic but my skills are novice. ive also tried formulas etc but none of it seems to be working.

If you need any info please ask......

any help would be appreciated

James

Welcome to the forum!

Can the built-in Filter tool fill your need?

You might be able to accomplish what you're asking for with a little bit of formula and a helper column; I'm thinking that you have a control cell, then check rowwise if it's the same as the control cell, then filter for TRUE.

Can you post an example spreadsheet showing what data you're working with, and how you want it to look?
Reply => advanced => "manage attachments" to launch that dialogue box.

Hi There,

The whole idea of this sheet is to make extremely easy for other user, so the built in functionality would be useless unfortunately.

Ive attached a photo of what I am after......

James p18_1.png

Originally Posted by JamesHansford

The whole idea of this sheet is to make extremely easy for other user, so the built in functionality would be useless unfortunately.

In my experience, "extremely easy to use" and "not using built-in functionality" are usually opposites.

Here's how I'd approach your problem, expanding on what I posted earlier:

1) Create a helper column (in D-column probably) that has this function:
=A5 = $C$5

2) Apply a filter to D-column for TRUE
--you can even hide that column if you like

3) Put a text box next to your C5 entry square and bind this macro to it:

Please Login or Register  to view this content.

Post the spreadsheet (as an XLS or XLSX instead of just a PNG screencap) and I can turn that back around for you to show what I mean.