compare 2 cell

Hello, I have sheet1 in that I have a column N "Due Date" {Date format} and Column V "Invoice Due Date" {Date format}, if both the values are the same then copy the Amount from Column X from that row and Paste to Sheet2. I request need a VBA code for this. I have attached the snap for better...

Hi, I would like to compare two cells in a worksheet. If cell T5 <> U5 then a message displays. I have VBA macro that handles this and its: If Not IsEmpty(Range("U5").Value) Then If (Range("T5").Value <> Range("U5").Value) Then MsgBox ("<Display message>") End If How do I continue this for...

Hi, I am comparing some data on types of differences: additions and deletions. I've used some code from a previous thread to compare two strings and find difference; and simply switched the WORDDIF arguments accordingly. =WORDDIF(A1,B1) Code: However, I have come to some obstacles. 1...

Dear Forum, I would like to check the date(stored as date in column j) falls after 01/05/2015, before 30/06/2015 and i= "sanctioned" then it should calculate f*1 else 0 for this i am using the below formula but i am not able to get the true value even though date falls between the mentioned...

Hi I'm trying to compare 2 strings of characters and have the result be the difference only. eg 37ArnsideStreetRusholmeOL145PH 37ArnsideStreetRusholmeManchesterOL145PH Result: Manchester I've tried using the Worddif VBA function but as my data has no spaces the result is the entire string...

Hi, I tried to compare 2 same result cell but it doesn't match. I put "=(1.81-1.73)/0.01" in cell A1, "=(1.95-1.87)/0.01" in cell B1 & "=IF(A1=B1,"Same","Not Same")" in cell C1. The result that I got are "8" for cell A1, "8" for cell B1 & "Not Same" for cell C1. How come it doesn't match? Did...

Hi, I'm fairly new to coding in VBA and would like to make a cell that shows a string based on the input from two combo box integers. Something like if X is chosen in cboBoxA and Y is chosen in cboBoxB then "xxxxx" appears in cell C and so on. I'm also wondering how to populate these cbo boxes...

I have data in two cells that is comma separated. I want to compare the values in these cells without copying them to new cells if possible. So if I have list of names, say, Cell A1: Person X, Person Y Cell A2: Person Y, Person X I want the comparison to return that the values are equal...

Hi, I want to: 1. Compare between 2 cells in first row of a big table. 2. If it matches (red color is the match words) copy the content of 'CustomerB to CustomerA' row by row. 3. Code inside the curly bracket {} , i'm not sure how to do this. <tbody> <tbody> CustomerA Dose Step 2 Target...