replace

Hi , I have a excel workbook which has 60+ sheets. In that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc.. Against...

I am working on data transformation with about 20 parameters to be replaced. The first part of the code with range A1 was simple and in worked. However, for some reason the second part of the code when I attempt to check the whole column starting from row 2 in column A is not working. Where is...

Hi, I'm really need help with this. Been trying to achieve this for the last 2 days. On my first worksheet, I have Values in column A and column B there are also values but they are hyperlinks. I'm trying to find the cells with the values from A across the rest of my worksheets and and replace...

I have a list of correct and incorrect names as seen in sample file below. I am trying to loop through a list of sheets and do a find and replace for each item on the List. The Correct Name is what the replace is going to be and the Incorrect Name is the find. I have looped through specific...

Hello, I am trying to build some macro that would replace some word from a table, based on a list of words, and paste each time the table one after the other. Example: Cat1 10 Replace Cat Horse1 10 Cat2 20 With Horse Horse2 20 Cat3 30 Cow Horse3 30 Cat4 40 Dog...

Hi there, I have an Excel spreadsheet and a Word document that work in pair. The spreadsheet is reviewed and updated regularly so the charts there represent the most up-to-date information. On the other hand, the Word document which contains the same charts (previously pasted as pictures)...

Hi guys, need help finding VBA code for this. Please see pictures attached. For example (Picture 1) IF I input 5 in (Sheet 1, Range C4), THEN the values in Sheet 1 under Row 8 should replace the values in Sheet 2 at the right side of special code 5, since the special or unique codes matched...

I have this VBA that imports a workbook("Sheet1"), instead of replacing the values each time I am trying to have a VBA to do it for me. The values change every so often, so it needs to be as universal as possible. I have no idea where to start for this. The correct values are in sheet ("Data...

I have no idea where to start with this VBA, but I have this column that I would like to replace the last two values to "T1" if they are equal to "**". Any help will be greatly appreciated. Ex: Column1 Column2 Result Bob WWWBN** WWWBNT1 Tyreek IFRYTFF** IFRYTFFT1 Jumbalie WROTMD WROTMD

Hello all, I'm attempting to run a macro over multiple workbooks which clean up, and add additional data into each workbook. For the most part, this macro runs correctly, however, one section will only run properly if stepped through in debug mode. If run normally it will have no effect. What...

Hello, I am working on a macro to edit a fixed width text file. What I want my macro to do is loop through each line of the text file (copy and pasted into column A) and replace a value IF the value of "RecordType" = 1. However, the line with the Replace function returns a mismatch error. Any...

HI My issue is it only replaces all instances on the ActiveSheet oSht.Cells should allow it to work on all cells on oSht Short Version Change: For Each oSht In ThisWorkbook.Worksheets oSht.Activate oSht.Cells.Replace What.... into For Each oSht In...

Hi Folks I've been scouring the net but without success. I'm hoping the genius's here will be able to help me :-) I'm trying to mock up some work for my daughter to help her with Synonyms and Antonyms. What I would like to do, if possible is: Column D looks at Column F (which will be hidden)...

Hi goodmorning all, hope you can help me place I have cells which sometimes has forexample -1, -4, -3 in them the range is cellsB24:P39, so what I do at the moment manually is CTRL F (find and replace) clickon replace tab – in find what enter (-*) and in replace with enter (0) thenreplace all...

I have a specified range selected. Range(ActiveCell.Offset(0, -9), ActiveCell.Offset(0, -3)).EntireColumn.Select Now, I have to replace all numbers with zero in the above range, except formulas. Can anyone help me?

I am trying to automate the ability to create IP address ranges An example Cell A1 has the value of 10.127.65.16 In cell B1 I want to keep the first 3 octets and replace the last octet with 10 (end result for B1 is 10.127.65.10) In cell C1 I want to keep the first 3 octets and replace the last...

Hello all i have a report that is giving me dates in the format of DD.MM.YYYY i am trying to convert this to a date format that excel will work with but i am getting some strange tings happening. i have used find replace to replace . with / but some dates are showing in a format of MM/DD/YYYY...

I've created a link with the HYPERLINK formula which is using customer IDs from another cell inside the Hyperlink. Works like a charm. Now I've been trying to make the Excel a bit nicer looking. Is there any way to replace the links with a button or a button-like graphic so it doesn't just look...

Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith

Hello, I have data sets I want to have code for that if I select a specific column, cell it opens a userform. The data set starts with a number such as 9334231/1 below. It will always vary in length. then another number, just different, indicates start of a new data set. If I was to select...