Trying to make a search function

ScotKersten

New Member
Joined
Nov 13, 2005
Messages
1
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?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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?
 
Upvote 0
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. :LOL: )

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.
 
Upvote 0

Forum statistics

Threads
1,211,961
Messages
6,105,088
Members
447,947
Latest member
OX_2005

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top