find and replace

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

Hi All, I have searched high and low for a solution to this problem. The system I use churns out Excel spreadsheets with the date format 00.00.0000 however, to get Excel to recognize this, especially when I want to sort and filter then I need to change the format to 00/00/0000. When I do this...

So I'm not 100% sure if Data Validation is the way to go about this or if there's an easier way to accomplish what I'm trying to do at all. Essentially, I'm trying to build somewhat of a custom dashboard where I'm able to select a name from the dropdown, and populate the metrics below...

Hello, I was successfully using this Multiple Find & Replace code (which is on several websites) for the last 2 years at my job and now it's been a few weeks it doesn't work anymore. I spent several hours researching a solution and trying a few tweaks but my knowledge in VBA is very little and I...

Hello there, I looked around and couldn't find an answer to this specifically. Basically I'm trying to write a macro that finds text that occurs in both the comments of a worksheet and a table (found on the "Translations" sheet). Then replaces the aforementioned text with the adjacent cell...

This is killing me! Ok, so not really. :) I searched this and other forums and haven't quite found the solution that works yet. I tried Kutools and almost got it, but the find/replace feature there didn't account for 44 not being the same as 444, etc and as soon as it hit the first 44, it...

Hi This is probably the simplest of questions. Windows 7 - Excel 2013 I have a spreadsheet extracted from a database - one of the columns holds information separated by ", " I would like this rather than in one long line to be 1 item above the next in the same cell - Find ", " and replace...

I am trying to find and replace part of a formula using vba by referencing the value of a cell. What I need to do: Find - Value of cell E10 on tab name "Admin"" within the formula in cell E8 of the "Submission Comparison" tab Replace - the string within the formula with value of cell E9...

I've spent a good 1/2 day searching for the topic, but it either does not exist or I am not explaining it correctly. I hope someone can help. I have a worksheet that tracks everyone's itinerary. If he/she is on "VC" (Vacation) or "SK" (Sick), the person is required to use specific codes...

Hello everyone, I have a big problem in my excel file. :mad: I created a data base which is "dowloading" data from 44 different excel files. The problem is: in my cells, formulas are different for one reference file (I have no idea how and why). Let me explain it: Reference file is in folder...

I run a quarterly file that contains 50 odd columns where I have to update links to other workpapers on. In order for me to complete the file I have to manually update the file links which is very time consuming. Is it possbile to edit the links altogether instead of having to go in an manually...

Hello, A range of cells in my workbook are linked to another workbook. I want to update this link (which is nested in an IF function) every month from E.g. update from 'I:\HSD\SD\PE\SA\IY\IYM 2014-15\IYM from SA\Social Assistance\DECEMBER\[SASSA 2014-15 IYM DECEMBER 2014.xlsm to...

Hi there Is it possible to find and replace within a formula? IE I have a formula which is a SUMIF and is looking up on 30+ sheets, I want to copy the formula but want to change column N to column X. Is there a way to do this quickly in one go do I have to do it manually? Thanks

I am trying to do a giant find and replace in VBA. It takes hours. I have to find and replace 2 areas in each formula of each cell. The parts I am changing link to other sheets. When I change the first part (Oct to Nov) but not the second (10-31 to 11-30) I get a popup notification which I...

Hi all I've been having some problems with the running the sub below (still WIP). running the macro kicks up an error, with ReplacedText.Value being highlighted, with the message "constant expression required". I think its an issue from earlier where I try to assign ReplacedText's value, maybe...

Hi there! I'm pretty new to VBA programming, but I built the Find and Replace function below that searches for the value in each row of the first column of sheet 5 and if it finds a match it replaces the format in sheet 5 to the cell in sheet 1. It works currently, but I'd like to change it...

Hi everyone! First time poster here, I do apologise if I contravene any forum rules. I am having trouble with missing aspects of the Find and Replace function. The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in...

Hi folks, Have an issue which bothers me for a year now, I receive every month a list with data from our website, users who registered in one of the cells I have the name and the email address but i need it separated here are an example of it what i have <tbody> charlie pink -...

I am new to the world of macros, other than I know that they exist. I know that if I can do it in Excel, then I can also do it with a Macro. Well I finally have a need. I know that I can do the following: Select all tabs in a workbook Find TEXT and replace with TEXT where TEXT is now in a...

I need to find information in the second column using information from the first and third columns. Referring to the table below, I need to find ALL tools that correspond to the part in column A, that are a part that is found in column C. I have tried a VLOOKUP to locate the value in the "Tool"...