find & replace macro

Hi, I'm very new to this, so my apologies. I've tried searching for the answer with no luck, although I'm sure this has been answered many times, I just don't know the correct search parameters. Basically, I want to search a row, if data matches in another workbook, then replace with data...

Hello Experts - Would need your kind assistance on the below to change values in all the sheet using VBA. This is my table in LookUp sheet, would need find the list in Check_ID and replace it with respective File_ID in all sheets. Kindly assist on this.

Is there any way to find whether excel workbook has any 8 digit number. E.g. 12345678,112233144 etc. could be in entire column or within in a statement on any of the tab of excel workbook. I need excel to find out any number(if any) in excel workbook. examples of 8 digit number could be present...

I am modifying timetables which have been exported from a separate application, but the way it displays the class names is suboptimal (and there's no way to change it in the application itself). I am building a macro to apply a number of formatting changes to the timetables quickly, but I am...

I receive a file each month where I need to do a find and replace on two columns. I highlight both columns and find and replace find "_GUAR" replace all with nothing find"," replace all with a space find "HEALTHMART" replace all with HM find "HEALTH MART" replace all with HM Here's what the...

I have pieced together different bits of code over the past few years to format a P&L report being generated from an accounting system. The vba is starting to run slowly and I'm trying to clean it up to make it run a faster. The report being formatted has 100 tabs and the code formats each tab...

Hello there, I have a worksheet with about 120,000 lines with probably 50 columns and I run the following code to change all the #'s to blank cells. I was wondering if there is a faster way to do this, because this takes a long time to complete. Sub NtoBlank() Cells.Replace...

Hi Folks, I have a column of data (column H) headed [customer reference]. Customer reference data is populated by users when they book a courier online. They have to input a client customer number (3 digits), a sales order number and a check digit, each element separated by a hashtag (so...

I receive a report that has row 1 headings that include "date" with cell text strings of "yyyy-mm-dd." What I produce is a series of date based windows. So the need is to look in row 1 for all occurrences of the string "date", select the column, find "-" & replace with "/" then format the...

I am trying to use find and replace to replace one formula with another. When I use my code with words in the string it works: Sub new() Cells.Replace What:="Hej", _ Replacement:="Farvel", LookAt:=xlWhole, SearchOrder:= _ xlByColumns, MatchCase:=False, SearchFormat:=False...

Hello Everyone, Need help with the VBA code mentioned in the end. Objective: To find all occurrences of text from Column A in Sheet 1 and replace them with respective value from Column B in Sheet 2 and highlight the replaced word(s). Issues with existing code: The code is not searching it as...

Hi, Does anybody have any suggestions / alternatives to modify the below code to allow find and replace multiple values on all worksheets? Also, if there is a way to fix replacing range, rather than having to select it each time? Thanks Sub MultiFindNReplaceNew() Dim Rng As Range Dim InputRng...

Hello people, I am trying to complete my work on one macro and is stucked somewhere in between. My problem is that if a cell contain certain value ( oranges word in big paragraph in the cell in excel), i need to replace it with the value given in the another cell ( in the other cell, the value...

So I'm tasked with taking one column in an Excel spreadsheet and converting those values into Latex (TeX) format and placing the formatted values in another column. For example, if I have CS3# in column A3 then I need to replace that with CS3/hash in column B3. Some symbols may contain more...

I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...

Hello everyone i have assigned a work in excel like find the word for example in column A i have list of words and in column B i have list of words so now i want to create a program like if i type particular word from Column A or Column B the cursor should go to that particular row where that...

Hey guys, I have a large file of links formatted like 'http://www.website.com/page/page/page.html' Looking for some VBA to clean it up First I need the 'http://www.website.com' removed and replaced with '^' second I need a string added to the end of the link. Here is what I have for adding...

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

Sub FindRiskWords() Dim oRng As Word.Range Dim arrExcelValues() Dim arrExcelValues1() Dim i As Long Dim x As Long Set objExcel = CreateObject("Excel.Application") Set objExcel1 = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("\\path") objExcel.Visible = False...

Good morning and thanks in advance for your help. A little information on what I'm trying to accomplish first. I have a reports where the cost center name is located in the title in cell $A$3 as "00-100 G&A". Throughout the remaining rows in column A the cost center name is repeated as...