compare 2 cells- 2 sheets

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

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

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

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

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

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

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

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