compare 2 cells- 2 sheets

  1. J

    Calculate sums based on values

    hey guys - this is a tough one and I am in DESPERATE need of your Excel Guru Greatness!!! I have two spreadsheets - one has leads - one has our ICP criteria on it. The ICP has like 10 questions with say 4 possible answers per question. Each answer has a "score value" so the answers are...
  2. rudogg

    Sheet Comparisons

    Fluff provided some great code in the thread below!!! https://www.mrexcel.com/board/threads1112978/ I have modified it a bit and I need some extra direction on it's functionality, if anyone could be so kind. Sub Match_Our_Price() Dim Cl As Range, mydiffs As Integer Dim Dic As Object...
  3. A

    Create a report dashboard to compare between two sheets data

    Hi, I have the below drug list shared by insurance companies each Monday, this list always varies with multiple fields such as drugs added/removed, drugs shifted to tier 2 from tier 3 or vise versa, unit price increase.. and all the the fields. example February 21 sheet lets call it sheet 1...
  4. M

    Comparing Data from 2 Sheets and Copy using VBA

    Hello all, I have data in sheet1 and sheet2. Sheet1 is source data and sheet2 is input. I want to compare data in column A and B of both sheets. i.e comparing as combinations. In the example below, the VBA has to look for combinations, if it matches in both sheets then data in sheet2 B column...
  5. W

    VBA code to compare data in two columns and update

    Hi, Have been trying to write a logic but not able to gte through, can someone help me with this. I have below data in A & B columns of sheet1. AB1Senior ManagerManager2GERMANOTTA, DOMINIC3BONOMO, MICHAEL4HALL, TAMARA L5PRADHAN, JEETENDRA 6RANGARAJAN, JAGANNATH K7STRATFORD, CHRIS8STRATTON...
  6. W

    VBA code to compare two lists and update

    Hi, Can someone help mw with a VBA code for the below. below is my input list AB1Name1Name22A3A14A25A36A47B8B19B310B211B412C13C514C615D16D717Grandtotal and this is my output list. AB1Name1Name22A3A14A25A36A47B8B39B210B411C12C513C614Grandtotal this is my expected output...
  7. G

    VBA for Sheet Comparison

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

    compare cells on different sheets and copy value

    Hi I need a little help. I need to compare the value in Sheet1.Col-E with Sheet2.Col-F if they're equal then copy value from Sheet1.Col-A to Sheet2.Col-E. Thanks for any help David
  9. D

    Comparing items between two data sets

    Thank you for taking a look at my issue. It is a little long but I have tried to explain it as concisely as possible and will be happy to answer any questions. The included example data shows what i would like the end result to look like. I am using windows 7, Excel 2010.</SPAN> I am looking to...
  10. J

    Macro Compare Cells

    Hello, I used a UserForm to enter information into a few cells in Sheet1. On Sheet2, I have a column of codes (ie 23456; 25678; 12345MD; 15389MD). I am trying to compare one cell from sheet1 to the top cell in sheet2, and if it does not match, move down the column until it does. The BOLD is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top