Trying to make a search function

[ScotKersten]

I am in need of some help here. I have read quite a bit on this board, but can not seem to find an answer to what I am looking for.

My spreadsheet has the following data in these columns. They are basically communication reports that have been sent out, and this is where they are logged

Column A = Date
Column B = Day
Column C = Topic
Column D = Keywords

What I want:

I want to have the user click a button to "search" the database we have constructed.

For example, they would search "economics", and it would search in Column D for all the lines that contain that keyword.

On a seperate sheet, it would copy over all that data.

Can anyone help?

 

[Zack Barresse]

Hello ScotKersten, welcome to the board!

Will you be having the user select unique entries to copy over from Date, Day, Topic or Keywords? If so, you may find it easier to create a UserForm with these topics. An example would be easiest, although it is a little difficult on this board. Does that sound about what you are wanting to do?

 

[HalfAce]

Hello and welcome to the board.
I agree with Zack. I think a userform would be one very good way to go.
That way you could give the users 4 different dropdowns (comboBoxes) to actually select what they're searching for and avoid problems like misspelling, etc. (You could do this without a userform too, but I like userforms. )

As Zack mentioned, they're a little dificult to show examples of on the board but emailing back & forth has worked great in the past.

Let us know what you decide.