setting up a search

[whitey987]

Hi, I have a very large sheet of data that I need to be able to search through, and display the results. What I require is help with setting up the code for doing this. I know you can use the standard find (Ctrl + F) to find data but what I want is to select the all the information retrieved from the search and then put it into a new sheet.
I was hoping to use a command button to trigger the search and text box as the input. Any help would be great.

 

[Andrew Poulsom]

Would AutoFilter and copying the visible rows work for you? What does your data look like? Post a sample.

 

[whitey987]

not really, as the type of of stuff im searching for is an keyword in an address. Say i have a list of addresses with a number of them in london, then i would search london and every cell with london in it will be displayed. But the different lines of addresses and not in different cells the entrie address is in 1 cell

 

[Andrew Poulsom]

Couldn't you Custom AutoFilter for column A contains London?