Compare value

[smartguy]

Hello all,

I have excel file in the below format.

Sheet1:

Excel Workbook
	A	B
1	Data	value
2	45	1245617
3	46	2547563
4	48	1234
5	45	1545454545
Sheet1

Sheet 2:

Excel Workbook
	A	B
1	Data	value
2	45	1245617
3	48	1234
4	45	1545454545
Sheet2

I want to compare data based on "B" column value Sheet1 to Sheet2.

i want missing data in to sheet3.

Answer :

Excel Workbook
	A	B
1	Data	value
2	46	2547563
Sheet3

Please help to provide VBA MAcro...

 

[MickG]

Plese provide a small sample of the data (for code2) where you get an error.
Mick

 

[smartguy]

Hi,

Please find the below Samples.

Sheet1:

Excel Workbook
	A	B
1	Data	value
2	45	1245617
3	46	2547563
4	48	1234
Sheet1

Sheet2:

Excel Workbook
	A	B
1	Data	value
2	45	1245617
3	46	2547563
4	48	1234
Sheet2

Both are sames i got error....

Error Line

Sheets("Sheet3").Range("A2").Resize(c, 2) = Ray

 

[MickG]

Hi, Add this (in Red) to both codes:-
If all data matches then c = 0, and you can't resize a cell by 0.

If c > 0 Then
Sheets("Sheet3").Range("A2").Resize(c, 2) = Ray
End If

Regards Mick

 

[smartguy]

Great Mr.MickG

It's Working Perfect....

Your one of the best key contributor in Mr.excel.com