search and match string

Hi. My first post but I hope I can get some help from You guys :) I've browsed the forums, but it's just to much for me at this time :/ I'm an intern and my supervisior asked me to do this task - but my experience with coding is meh What I need to do is to get a sting from column x row 1 to...

I am working with excel 2010. Here is an example of what I am trying to do A column Crisp prawn dumplings with green tea salt Roast fennel, mint and ruby grapefruit salad B column Bacon salad mint dumplings tea beef RESULT C column dumplings tea mint salad I am trying to...

I am trying to get the userform to search column B depending on the user input in a text box and then populate text boxes in another userfrom from the cells found in the excel row. the code i have is: Private Sub Printer_Find_Click() Dim ws As Worksheet Dim rng As Range ' possibly...

I have been getting this error: "run-time error 438 object does not support this property or method " when trying to get a click button to search a spread sheet find a value from the entered text box and then read the cells and input them into text boxes in another userform. this is the code i...

Hello All, In Excel VBA, I am trying to create a single macro that will A) search for a string (let's say "Bay") within an entire worksheet B) return all results of the search containing the string in a list ("Bay st", "Bay Av", "Bayview", etc.) C) allow the user to select one entry...

Here's a much shortened version of my spreadsheet... where the numbers are meaningless... jim 100 400 600 jim 200 300 800 jim 150 250 350 pam 100 200 300 pam 100 200 300 tim 200 300 400 tim 400 500 600 jim and pam are just 2 of the 17 employees in the Cash Applications...

What I am trying to do is find a string in one worksheet and if it matches the content of another worksheet, then it copies certain texts to it. I have been able to do that, but where I am stuck is if the same string matches the string on the other worksheet then it overwrites the previous...