string search

I am looking for a VBA code to search through 3 columns and search for a text string. In column a, I would like to search for 596Y. If it is found, I would like to create a tab for that line of data and include the header. Then for the next search, I need to look in Column B to find a list of...

Hi All, I have a nicely aligned workbook but there is one small part I am trying to figure out. Our Product unit numbers go from 1-50 however they are all within a string for that product code. I know how to get figures to the left and the right etc but I want to get figures in between certain...

Please forgive the length of this request, as I will try to give as much information as possible. I have a database that consists of three different sheets of information that correlate together. In one of the sheets, is a list of IP addresses that form a path through a network. I need to set...

Hi Gurus ! I have a big database of Employees that has a unique key "ID No." now What I want is that if I enter 'Jon' in a cell then the I should be able to find all employees who have substring Jon in their names, and their names & ID no. should appear as a list. The expected result is...

Hi, I have searched through the forums and found a macro that will search one column for a word, copy the row, and paste it onto a new worksheet: Sub COPYROW() Dim rcnt As Long, result As Long rcnt = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row result = Sheets("Sheet2").Range("A" &...

<TBODY> I want to search a string to find a value to lookup against for a vlookup, but am new to vb etc so not sure where to start. Example I have a list of cars and there type; GOLF 5DR TDi, A3 3DR 140 or 2DR A5 Cabriolet etc etc including loads of different details. With a lookup list of...

Hi Everyone, I have almost 90 different workbooks and in each of them there are like 5-10 sheets. I basically have to search through Each of these sheets in each workbook to find a Value NEXT to a certain cell. e.g. If in a sheet, in a particular range it is written "Contract Value:" then i...