search text

I have a sheet that has cells with lots of text. I want to search the cell and see if the text exists. Below is the type of data I have. For reference, assume this is columns A and B and row 1(header) and 2 (text I need to search) I used Countif to search for "*active" in the range below and...

needed help again.... what I'm trying to do is, loop thru the range (until last row) and delete entire rows if cell is empty/blank or cell value not equal to "PAID" below code does not seem to work LROW = 2 Do While LROW <= LastRow If (IsEmpty(Cells(LROW, 4)) = True Or Not...

Hello all, I have attached a sample sheet to better understand my problem. What I need is, search for "Location: KL" in column A of Sheet1 and then search for "Product 1" in the same column, but include only the cells after the text "Location: KL" in the search. Then get the "Product...

Hello, I am trying to return values if either criteria is found in the item description. For example if the text in Column G is found in Column A then I want the value in Column H to return; and if the text in Column I is found in Column A then I want the value in Column J to return...

Dear all, I've been looking high and low for a macro that will help me copy a certain row based a specific string in a cell to a new sheet and the first empty row in that sheet. Please help me figure this out. Context: - One Excel file - Two sheets "JiraData" and "Dash". Please note that...

Hello all and thank you for your help. I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes. I need to perform the following functions and return a single value: 1) Search a text string in a single cell to...

I know this is going to be an easy answer and I am almost there (I hope), but I need help because I can't get the correct result. I have 2 columns of names and one column has 7 characters that need to be replaced and then the result of the first 3 characters compared to the other column to see...

So I have a log at work for orders from people in the office that is the format: "Person Who Placed Order"-"Person Ordered For" The account number in the next cell is represented only for the "Person Ordered For" and should correspond to their name. Since there are a large number of orders, it...

I'm using Excel 2003. I have a file with columns as below: (below diagram, the cells are separated with '|' and '-') _|_A__|__B__|__C__|__D__| 1| 1-Jan | A,B,C | 1-Feb|C,D| ----------------------------------------- 2|2-Jan | B,D | 2-Feb|C,D,E| ----------------------------------------- 3| 3-Jan...

I have the code below that takes the user input from a text box "strtraveler" (a traveler number typicall looks like 12345p678and finds what the user inputs on the sheet and moves it to another area then deletes it from its previous area. This is case sensitive and I don't want it to be...