compare cells

I found this code online guys and I need help updating it. Sub Macro1() Dim xRg1 As Range Dim xRg2 As Range Dim xTxt As String Dim xCell1 As Range Dim xCell2 As Range Dim I As Long Dim J As Integer Dim xLen As Integer Dim xDiffs As Boolean On Error Resume...

Hello, I am working on a project that I would like some help on, i have a list that is delivered at 9 am everyday to the same file location. The list is formatted the same everyday, however there are changes. I need to find and record the changes between each day the list is generated. What i...

Hi All, I have a xcl spreadsheet which has two worksheets (Sheet1 and Sheet2). Sheet1 has three columns (A, B, C). Sheet2 has 6 columns (A,B,C,D,E,F). What I am trying to achieve is as follows If Sheet1!A2 matches the contents of a cell in Sheet 2 column A then copy the values from Sheet2...

Hello, I have created a multiplication test for 2nd grader. The goal is for him to fill out the table on the "Test" sheet and then run my macro. The macro would then compare his answers to the those on the (locked) "Answers" sheet. The macro would then display a MsgBox with the number of...

Hello everyone, What is the best method or combination of methods to go about finding the most recent year for a Bachelor's degree in a row and inserting that year into the column shown below in the example picture? I've already populated the column in my example. Sometimes the most recent...

I have a simple problem looking for a simple solution. I want to compare two columns, A and B, and delete the A cells that are equal to the B cells...I have 3000 rows... If Cell A1 = B1, Then Delete A1, next row... Thanks for any help you can give me on this!

Hi, We have over 1000s rows in two worksheets, we have matching SKUs and but in random order but of one SKU exist in both worksheet. And need compare entire cells from two different worksheet and and return the price to worksheet A Please Advice WorkSheet A <tbody> SKU (A) Price (B)...

Dear Gurus, i have a simple table Column A cell A2 text Value "Soren Petersen" Column B Cell B2 text Value "Soren Petersan" since there is a difference in the second last alaphabet which in Col A it is "e" character and Col B it is "a" character i want in Column C Cell C2...

Hi, I am comparing the signs of rows in 2 columns. If the sign is different, I want to multiply the 2nd column by (-1). I have the code below, but it is not working. For k = 2 to k If sgn(k,"O")<>sgn(k,"P") then range("P"&k)*(-1) Next k End If

Hi. Been going round and round in circles trying resolve this. I have 3 cells and would like to detect a combination of values and return a different text string dependent on results. Each cell can be anything from 0 to about 10 and I am testing whether a cell is above 2.5 or not. So if all 3...