Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database Search For Help?
I apologize for posting this a second time (it is already on the Programming
board), but I need help on this as quickly as possible and thought that perhaps some people who read this one could help me as well. Thank you again. === My task is to make a form which does the following: It needs to search an Excel worksheet for a string of text entered by the user and then spit out a new worksheet with only rows containing that data. Seems like it should be very easy, but I am completely new to Excel and all of my attempts thus far have failed. I'm trying to learn some basic VBA as quick as I can, but some help would be absolutely wonderful. Basically, the way it should look is this: there should be a box which asks for text, let's call this SearchString. And then there should be a button beneath it that begins the search process (let's call this SearchStart). After pressing the SearchStart button, the user should see all rows containing the previously-entered SearchString in a new worksheet. Easy as that, but I don't know where to begin. Can someone help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
Creating A Search Database..Need Help | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions |