Related:

- Comparision of Excel sheets
- How to copy data from one excel sheet to another using formula - How-To - Excel
- How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
- How to compare two excel sheets ✓ - Forum - Excel
- How to copy data from one excel sheet to another ✓ - Forum - Excel
- Auto notify of email when excel sheet updated - How-To - Excel

Mehedad

- Posts
- 22
- Registration date
- Thursday April 19, 2012
- Status
- Member
- Last seen
- April 16, 2013

A sample data would have been useful which would have showed what values are being compared. However, assuming that you need to copy a single Cell in Sheet 1 if the data is not matching, it can be done using formula:

=IF(A2=Sheet2!A2,"Match",Sheet2!A1)

Little more details would have been helpful. Let me know if it worked.

=IF(A2=Sheet2!A2,"Match",Sheet2!A1)

Little more details would have been helpful. Let me know if it worked.

pws

Hi,

I am looking for copying row values to sheet3 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A).But i need only difference values.

Lets take a look below:

Sheet1 contains :

columnA ColumnB

ABC 10

XYZ 20

LKJ 30

Sheet2 contains :

columnA ColumnB

XYZ 20

ABC 50

LKJ 30

Now i need in sheet 3 like below:

columnA ColumnB

ABC 10

ABC 50

Because ABC having different values in sheet1 and sheet2.

Please provide me a macro code so that we will get reports based on fileds to compare.

I am looking for copying row values to sheet3 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A).But i need only difference values.

Lets take a look below:

Sheet1 contains :

columnA ColumnB

ABC 10

XYZ 20

LKJ 30

Sheet2 contains :

columnA ColumnB

XYZ 20

ABC 50

LKJ 30

Now i need in sheet 3 like below:

columnA ColumnB

ABC 10

ABC 50

Because ABC having different values in sheet1 and sheet2.

Please provide me a macro code so that we will get reports based on fileds to compare.

TrowaD

- Posts
- 2674
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 27, 2020

Hi pws,

Start by copying both columns of both sheets to the 3rd sheet and sort them alphabetically.

Data looks like:

Column C is used for formula:

Cell C2: =IF(A1&B1=A2&B2,1,0)+IF(A2&B2=A3&B3,1,0)

Drag formula down.

Filter data on "bigger then 0" and delete the visible rows.

You can then remove the filter and delete column C.

Best regards,

Trowa

Start by copying both columns of both sheets to the 3rd sheet and sort them alphabetically.

Data looks like:

ColA ColB Header Header ABC 10 ABC 50 LKJ 30 LKJ 30 XYZ 20 XYZ 20

Column C is used for formula:

Cell C2: =IF(A1&B1=A2&B2,1,0)+IF(A2&B2=A3&B3,1,0)

Drag formula down.

Filter data on "bigger then 0" and delete the visible rows.

You can then remove the filter and delete column C.

Best regards,

Trowa

It WORKED..

But I need COMMENTS that are in a Cell also as a PART OF PARAMETER

for comparison.In other words "EXACT MATCH" .of cell to cell

Please help me I am comparing 7 years data comments in a cell ( that was lost) just recovered with adhoc data (without Comments

Please help me

regards

ansharma

Could you provide a little sample of your data how it is and how you foresee it.

Best regards,

Trowa