find & replace in formula

Hi All, I am trying to replace an equipment number in a formula with the contents in a specific cell per row. I have the VBA text string for the replacing of one row, but I need assistance in duplicating the action for each row where each replacement text is in a different cell. below is the...

I am working on a fun project that will automatically update all of the stats for NBA players. As a part of this I have three sheets for each team (total stats, home stats only, away stats only). I built out the first one without any problem, but if took a lot of time since I am referencing a...

I have a big data excel file, there are many negative numbers. Now I want to highlight all the negative values and then multiply it with a specific number (for example 0.5). Could you kindly show me how to do it? Thank you.

Hi, So basically I have 4 main possibilities: PYMT769291 INV 769291 INV 769291_1 -> This could be _2 or _3 or _4... INV 769291BD And I need 1 formula that makes them all convert into this: PYMT769291 -> This one should never change 769291 -> This one gets rid of the...

I have had to merge two copies of a workbook and to do so requires me to find all references to cells that may have now a different location. I am using the find function to locate all the cells and trying to use the replace all function to speed things up. The only issue I am finding is when...

Hello everyone, My goal is to find all YELLOW highlighted cells that are currently empty, and replace it with a vlookup formula like this: =Vlookup(A1,A:Z,2,False) The issue is when you use the Find and Replace function, the lookup value of A1 is an absolute value. I need the lookup value to...

Hello, I am hoping someone can help me with this.... I am trying to do create a macro to substitute part of a formula in column 'S', cells '1-254' on the worksheet “Original_Formula_Sheet" (so the range is 'S1:S254'). The formula essentially has a $503 absolute variable in it, and I need to...

Hi, so my problem is that I have a file that will serve as a master document called TwoWeekLookAhead.xlsm that I need to be able to rename and have the macros all reference the new document. To do this I can just manually find and replace all the VBA references to TwoWeekLookAhead.xlsm with...

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="2" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody></tbody> <tbody> A B C D 1 String BadWord GoodWord 2 baseball hckey hockey 3 hockey basebll baseball 4 I love...

I have a list of thousands of URL's that I need to regularly edit and I have been manually doing this with a find and replace, but I would like to automate the work. Unfortunately there is very little consistency in the domain structure and a text to columns approach won't work. I need to do...

I have some code that isn’t working right. On the Student report page, I’ve written a sub that should change all cells’ formulas to the row number I specified. It successfully changes the formulas in cells A3:A6, but doesn't for any other cells. It’s not throwing any errors, the error handler...