#replace

Hi Everyone, I have an annual assessment form that collects data from certain fields and based on the grading given to those fields, specific comments will be generated on column "AH" for each respective employee. All those comments state "Employee" at the beginning of each sentence. What I...

Hello, I have over 802 formulas that I need to update with a different suburb for each formula. This is the formula: =IFERROR(GETPIVOTDATA("Count of Works Commenced Date",'SAG Pivot Tables - Locked'!$EV$3,"Suburb","Acacia Ridge","LGA","Brisbane City Council"),"0") I need to replace the...

Hello, see below, I need to add the letter "J" to the end of the value in column D, also changed the No to Yes (If J is already present, or if Yes is present, then do not modify these values) IF these conditions are met: the word "Brevard" is in column M on the same row, the word "sanitary" is...

I need to change a group of values to value A, and another group of values to value B Below is what I have so far, and the code is not working. what am I doing wrong? Sub CleanUpOutlier() With Range("D1", Cells(Rows.Count, "D").End(3)) .Replace "F21222CJ-08"",F21222CJ-11"""...

I have a large number of excel files to clean up, any of the values contained in these arrays will be replaced by a different value Below is what I have so far, any help is greatly appreciated Sub CleanUpOutlier() Array1 = ("1", "2", "3", "4") Array2 = ("5", "6", "7", "8") With...

I have a few thousand excel files that need to be modified, one of the modifications is changing the value from Yes to No in column E based on value from column D. For example, if value in D is: F13345C, or F13355C, or F13365C, and if the value in E is Yes, this Yes will need to be changed to No...

I have a bunch of excel files that contain some values in column D Whenever there are values in this format, with a dash: F12314J-67" (yes with an inch mark at the very end), they need to be replaced with something like : F12314J I've been working on this for a while now and my code so far is...

I am fairly new to VBA. I need to create a macro that searches the entire column K for keywords " C Box", for any cell in this column that contains these keywords, I need to add a numerical value to the end of the text (this numerical is always in the same row as the cell that contains the...

Hi all, I'm new to VBA and while trying to learn this new language, need to figure out a way to do something for work ahead of my current skill level. I have two sheets, in each there are hundreds of rows of the three columns listed below (I'm only using 1 row but would need this using a...