find

I've been racking my brain over this for a whole day now and cannot figger out why my VBA FIND command is not coming up with results. Here's what I have: It's an XL workbook used to compare Electricity prices for suppliers who have Peak and non-Peak charges. The worksheet "Electricity- Peak-Off...

Hey everyone, I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to...

Hi, I am trying to find text in one spreadsheet ("PerformanceT2") in column ("E") and the copy cells from the row in which text was found from columns ("E") ("F") and ("V") from that spreadsheet ("PerformanceT2") and then copy these cells into different spreadsheet ("Cal.PerfT") and paste them...

Hi, I have a program where text to be displayed could be 1 or multiple lines. I want to display the text in a specific form and I have multiple forms for 1-line, 2-lines, 3-lines, etc. All good as long as I know how many lines are being required. In some cases though, I don't know that, so I...

ABCD1Copied EntryExpected Result2Dog*Brown,White,Black,Dragon*Golden,Green,Red,Black,Panda*Red,Black,GreenDog*Brown,White,BlackDragon*Golden,Green,Red,BlackPanda*Red,Black,Green As shown above I would like to parse the cell value for every "*" entry to arrive at the expected result, below is my...

Hi all, I'm working on a macro that updates a database, based on the input of a form. This form is located on a different sheet. My code was working fine all the time until I noticed that it didn't perform any changes when the macro was run from the sheet with the form. That's why I had to...

Hi , I got a column of 1000 numbers (fromD1 to D1000) and need a piece of code to do the below, while in A1, finds the very bottom non-empty cell in D (D1000), CUT the content and paste it in A1. then go down for 27 cells (to A27), again find the last non-empty cell of col D (which obviously...

I have written a code, which includes the FindNext method. All the code works so far, only when it gets to the FindNext method it shows an error saying the FindNext Object cannot be assigned. However, I don't see where the Range Object (in this case "cell") is changed in any way for the FindNext...

In a workbook with multiple sheets, I want to find the address of a cell containing the string "MIS", which will always be in a sheet in which cell A1 begins "P " (with a space after the letter P). I then want to save this address to a range variable and pass it to another sub which will set the...

Dear cordial greetings I am learning the basics of Excel's VBA language, and I have come across the issue related to the default color range. Investigating in different sources I have found a code that allows to obtain the values for the RGB primary color palette, presenting them all together...

I want to mach 2 columns A is the unique list of name's static B is unformatted console list In C want Names that matches,and very close and higher/approximate possibile name to get captured In D column is any way to put an remark 100%,90%,80%,.....no match...

Hi, Sorry for two posts about the same thing, won't let me delete the first one. I want to create a VBA code so that I can look up the string "Category 1" and use it as a reference to add a certain number of columns based on another cells value. The new cell values are to have the headings...

I have a large spreadsheet with more that 400K rows of data on Sheet(1) with several columns but one column H contains URLs. I can copy the URLs to a another sheet in the same book (Sheet(2) = "UniqueURL") in column A and only display unique URL in alphabetical order (with heading). I then...

I have a spreadsheet that already has some macros that setup SUBTOTAL functions where I would like there to be SUM functions. The code that creats the SUBTOTAL functions I believe is this... Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(22), _ Replace:=True...

Hi all! I want to create a macro that will find a certain column, based on the value of a cell in that column, and copy/paste values the data from that column to another sheet. The reason why i need it to find based on a value of a cell is because i have "customizable"/"moving" columns and...

Hi, I'm doing my first post here. Please excuse me if this is silly. I have col A and col B as text fields. In col C I have a query list. I'm trying to find if the text values in both col A and col B exist anywhere in col C and then return a true or a false. Please see the attached sheet...

Hello guys, firstly i want to sorry my English, because i'm not using the translator. I hope you can understand what I writed. So, i maked a macro that open the find dialog box and search for the word "lote". My macro: Range("A1").Activate SendKeys "^lLOTE" Range("A1").Activate...

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...