find

Hi, The program reads each row of Sheet 1, scans the three criteria we are looking for and it should find the entry in Sheet 2 that matches the criteria. Criteria: 1) invoice number (location in Sheet 2: column D) 2) date of payment (location in Sheet 2: column B) 3) amount paid (location in...

I am hoping that some one could help me out with the following code. I am getting an error 1004 - application defined or object defined error but Iv no idea why. Its showing on the line... Set srchheader = Worksheets("Data").Range("G2:G" &...

Hello, Is there a way to find "used" products from my list of "out" products and "returned" products? Notes: "out" and "returned" products may have the same product code we ship "out" about 100 products (some have the same product codes) and they "return" 90 products Example: OUT RETURNED...

I have a file that references Bing API lookups through webcalls. When loading the sheet, sporadically, many of the calls work fine, and others throw out an error code and need to be refreshed. Re-pasting the formula to all cells again causes even some of the cells that were just loaded fine...

Hi, Anyone can help me with the right formula to extract the last text from the right. In below example, I need to extract whatever text comes after ABCD 1 or ABCD2. AB1TEXTExpected Result2012 - USA - ABCD 2 GreenGreen3011 - USA - ABCD 1 RedRed4013 - USA - ABCD 2 YellowYellow5014 - USA - ABCD...

Hi, I have this function that searches column A for words that I listed in column D and returns "found" or "not found". In the formula below, I only have to search for 4 words in column A so the formula refers to $D$4:$D$8. =IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$4:$D$8,A5)))>0, "found", "not...

Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. My log file has the following structure: . . . === NAME: xyz123 === d1: ABCD, d2: EFGH e1: TRUE (12345) . . . . == Specific text == Not every log part ends with the ==...

Hi, I'm wondering how best to approach this... The formula I have in I2 is: =IF(RIGHT(H2,5)="00000",IF(ISERROR(MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),H2,MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),"")...

I am trying to figure out how I can check if a value in a combobox is a date before running a find in VBA. The code looks like this: If Not IsError(DateValue(ComboBox1)) Then Set FindMe = DataSH.Range("A4:L1048576").Find(What:=DateValue(ComboBox1), LookIn:=xlFormulas, _...

Hi, I have one excel sheet with the date 30/01/2021 custom formated with "d" to show me only the day (30). When I try to find the same date, in the format 30/01/2021, with "Find and Select" I get the message: "We couldn't find what you were looking for. Click Options for more ways to search."...

Hi All, please check my code below, this code finds number in Main sheet and makes color change in respective sheets based on its usage lets say if the usage app in main sheet then code makes perticular row to green colour in other sheets if the usage is Ex then it marks that row in yellow...

So I have data in a column that is delimited by spaces. It would be simple to delimit by the spaces to get the desired result but the data is not as you can see below: 5pt 3rb 1st 1bl 1-2fg 3-4ft 0pt 5rb 1as 3bl 1to 0-3fg 4pt 5rb 2bl 2-8fg If I delimited by space, I would have st...

Is it possible to find a row with 2 criteria? I'm importing survey anwsers to a worksheet, now I want to find the answers of a specified person I need to find the row in the worksheet(ImportLimesurvey) that has 2 specified cell values: In that row: the value of the C-cell has to be one of the...

Hi, I have a set of codes and I want to find the next available code. Below is an example for it. So if I enter 02-002 then I should get the next code available which is 02-002-0004. I am looking for an excel formula instead of VBA code. Thanks for your assistance. Product Code Input...

Hi All, I am trying to loop thru each account in my account master, find the range of cells 7 rows over in the next tab, copy those cells into a calculation sheet with a multiple the values, then I want to paste the end result back into my account master sheet. I am able to get the 1st account...

Hi All, I'm trying to find all instances of a client name and copy the range into a new workbook where I want to perform a calculation. These are my headers and I want to do a find on the client account number, such as 5 and then copy the range. My existing range runs from A1:I71573. I have...

Hi everyone, Here is an extract of my database. In the "Score" sheet we have different columns from which I have to find specific words to match with those from "Data" sheet. I would like to create a macro : If there is more than 1 Instr in columns C, G, K and O then columns S, T, U and V are...

Team.. Need your help again. I believe it is possible for Excel to find key words as described by user and paste the same in the dedicated cell. And I also believe this can be done without using a Macro. Please help out on the below.. I prefer not to use Macro's if possible please. Keyword and...

Hi everybody, I have a list of records (string type) and another list of words & prices. i want to check if the string contain the one of the word from the list (max 1 word) if its exist in the string take the price of the word. for exp Bosch Power Tools Combo Kit - string combo kit - word...

Hi I have a list of addresses in column A of Sheet 1 in a file (please see the 9 rows below). I will regularly need to populate the 'City' name in column B of Sheet 1, using the City names from column D of Sheet 2. And I've been advised to do this manually, but I'm sure there's a formula...