find & replace

I ahve a report that I must update each week. Throughout the report are references to another daily report of the format: 20140610_DailyReport So each week when it comes to updating I am supposed to CTRL+H and replace 20140603_DailyReport with 20140610_DailyReport But when I try that now...

I am trying to use Find and Replace to find the pipe symbol (|) and replace this with a carriage return. The ctrl+shift+j does not work for me on the Mac keyboard using Excel 2011 for Mac. If I go into my VM running windows and Excel, then it works just fine. Thanks, Benje02

Hi all, I am trying to find a macro that will find the same entries in Column A and for all of the duplicates except the first one change the value in column T to 0. I don't want to remove the column because in column A I have the order number and in column T I have the total amount of cart...

Hi everyone! Thanks for checking into my issue and I appreciate any responses I'll get. I have a database that has thousands of cells that I need to find/replace monthly because the formula needs to reference the correct month's data folder from another workbook every month. My issue is that...

I'm making a schedule for school. The school website will give me an excel document of all the games and practices put in. I download the list and then paste it into a formatting page that will then link to all the other scheduling formats and needs I have. The time's of the practices come...

Hi, I have a set of data that I am splitting with a macro based on period placement. For example, this: 1. Joe Smith 2. Mary White 3. Ted Jones is split into: Joe Smith Mary White Ted Jones My macro works fine except when someone has a period in their name, which creates a situation such as...

Hi everyone-- I have a worksheet that is split into months columns (January, Feb, etc...) and I have about 10 different tests with 10 test questions listed down the rows...basically I have 100 or so cells that need updating month to month. All of these cells are pulling data from a shared drive...

Hello All, I have a problem that I just can't seem to figure out. :confused: After using a vlookup formula, and a if then statment I found out that there are duplicates on my other sheets. I want to use a Macro to use the duplicate value in search and find to locate the item and highlight it...

Hello - Here is a formula which returns the value from another sheet found at the intersection of a column range (d12.31.12, which is a date) and a row range (Room250, which is a location). =(INDEX(d12.31.12,ROW(Room250),)) I have 52 similarly named columns (one for each week) and a dozen or...

Is there a way to run the codes below on every sheet in my workbook? I have 50+ sheets (tab1, tab2, tab3... tab50...) I musto to change column B and X to upper case and after do action find and replace. I using 2 macros, 1st is for change case to upper case, 2nd for find EXAMPLE 1 and replace...

Hi, So I have a bit of vba code that I run on lots of different files. The file names are all dependent, so I have a1_s1, a1_s2, a1_s3; a2_s1_, a2_s2_, a2_s3 and so on. What I'm doing at the moment is running the code with the file name a1_s1 in the sub, then doing find&replace, and replacing...

I am trying to Find and Replace the combination of two letters, "OM". However, in this column there are also words such as "From" which I don't want to change. How can I match only "OM" while excluding everything else in the cells?

Originally I had a large sheet (named MASTER LIST) and an analysis sheet (named ANALYSIS). The Master List ended up with the million plus rows issue that I could not resolve. To address this problem, I copied and pasted into a new sheet (named LIST) my entered data plus a few thousands rows for...

This seems like a fairly basic task, but I'm fairly new to VBA and I'm still learning the appropriate syntax. In a simplified way it goes like this. I want to create a macro that takes the stores three different variables that the user types into an input value box. V1, V2, V3 I need the macro...

Hi Guys, Does anyone have a clue how to cycle through image's in an image control called "image1" using a commandButton "CommandButton1". I have 4 images that I want to cycle through "L001, L002, L003, L004" that I need to display individually in "image1". I have the Pictures in a folder...

The aim of the code is to take a template (“Original”) and perform a “find/replace” on it for a number of inputs which are set out in a table (in “CaseMatrix”). The code then duplicates the template in new tabs based on the number of rows in the table. i.e. 5 rows = 5 new tabs based on the...

I have an excel macro that copies a tab from the previous month, renames it to the correct month, and replaces the formulas with the correct month/formula. The issue I ran into is that when it replaces the formula with the correct month, it returns #Value and says "wrong data type". I believe...

Hi All, I am looking to create a macro that will automatically find and replace a number of different values in a worksheet. e.g. there may be 50 instances of '59df7-0bd0' that need replacing with 'James Norris', and there may be 50-odd variations to include. Any other solutions that I've seen...

Hi all, I have a dropdown box containing text strings. How can I use the selection from a combo box as part of a formula? So for example I have a spreadsheet that is set up using a search term 'media', I want to select something else from the list e.g 'arts' and I want all of the references to...

I have the following formula in column B of a worksheet: =IF(INDIRECT("Programado!B4")="","",INDIRECT("Programado!B4")) The formula's purpose is only to display what text/value is found in cell B4 on the Programado worksheet of my workbook. Because this is an indirect formula, when I fill it...