machn mage excel worksheets 2k thiyenava. e dekema id,name kiyala column dekak thiyenava
mata dana ganna ona worksheet1 vala thiyena table eke id ekata adala name eka worksheet2 eketh thiyenavada kiyala.
ex:-
worksheet1 (id - 001, name - kamal)
worksheet2 (id - 001, name - nimal)
mekedi machn id eka eka samana unata name deka venas.mata one anna e wage ewa identify kara ganna vidiyak
excel macro valin puluvan neda? mama karana vidiya danne ne
danna kenek poddak pahadili karala denna puluvanda?
mata dana ganna ona worksheet1 vala thiyena table eke id ekata adala name eka worksheet2 eketh thiyenavada kiyala.
ex:-
worksheet1 (id - 001, name - kamal)
worksheet2 (id - 001, name - nimal)
mekedi machn id eka eka samana unata name deka venas.mata one anna e wage ewa identify kara ganna vidiyak
excel macro valin puluvan neda? mama karana vidiya danne ne
danna kenek poddak pahadili karala denna puluvanda?
PS:
mama code ekak hoya gaththa. kata hari wadagath vei
Code:
[SIZE="5"][COLOR="Orange"]Sub RunCompare()
Call compareSheets("Before", "After")
End Sub
Sub compareSheets(shtBefore As String, shtAfter As String)
Dim mycell As Range
Dim mydiffs As Integer
For Each mycell In ActiveWorkbook.Worksheets(shtAfter).UsedRange
If Not mycell.Value = ActiveWorkbook.Worksheets(shtBefore).Cells(mycell.Row, mycell.Column).Value Then
mycell.Interior.Color = vbYellow
mydiffs = mydiffs + 1
End If
Next
MsgBox mydiffs & " differences found", vbInformation
ActiveWorkbook.Sheets(shtAfter).Select
End Sub[/COLOR][/SIZE]methanin gaththe
https://www.mrexcel.com/forum/excel-questions/484144-compare-two-sheets-highlight-differences-sheet-attached.html
Last edited:
