Home » Spreadsheet Software » Compare Two Excel Spreadsheets For Differences 2010
Compare Two Excel Spreadsheets For Differences 2010

Compare Two Excel Spreadsheets For Differences 2010

Compare Two Excel Spreadsheets For Differences 2010 – I can not find the right code for power. Calculation of the sheets of the calculation of the same book, basically with the form of three columns, code, quantity and article, is for an inventory, sheet is the first content and sample sheet Second count), now I can not create a code To give me the only products that do not match and their respective difference. Any ideas?
BuscarV does not serve me because it may be that one of the templates has an article that the other does not have, and the code for me is killing, if you want to send!

You must Try this :
Sub difference ()
Application.ScreenUpdating = False
Sheets (1) .Select
Range (“a2”). Select
Do While Not IsEmpty (ActiveCell)
Code = ActiveCell
Amount = ActiveCell.Offset (0, 2)
Article = ActiveCell.Offset (0, 1)
Sheets (2) .Select
Range (“a2”) Select
Do While Not IsEmpty (ActiveCell)
If <String> ActiveCell Then
ActiveCell.Offset (1, 0) .Select
Else
If code = ActiveCell And ActiveCell. Offset (0, 2) = amount Then
ActiveCell.Offset (1, 0) .Select
Else
amount2 = ActiveCell.Offset (0, 2)
Sheets (3) .Select
Range (“. A65000 “) End (xlUp) .Select
ActiveCell.Offset (1, 0) .Select
ActiveCell = code
ActiveCell.Offset (0, 1) = article
ActiveCell.Offset (0, 2) = amount – amount2
Sheets (1). Select
ActiveCell.Offset (1, 0) .Select
Exit From
End If
End If
Loop
Sheets (1) .Select
ActiveCell.Offset (1, 0) .Select
Loop
Application.ScreenUpdating = True
End SubSelect ActiveCell.Offset (1, 0) .Select Exit From End If End If Loop Sheets (1) .Select ActiveCell.Offset (1, 0) .Select Loop Application.ScreenUpdating = True End SubSelect ActiveCell.Offset (1, 0) .Select Exit From End If End If Loop Sheets (1) .Select ActiveCell.Offset (1, 0) .Select Loop Application.ScreenUpdating = True End Sub

 

Compare Two Excel Spreadsheets For Differences 2010