Reply to thread

Message: <blockquote data-quote="Sea1men" data-source="post: 23452141" data-attributes="member: 554883">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? PS:mama code ekak hoya gaththa. kata hari wadagath vei <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" />[CODE][SIZE="5"][COLOR="Orange"]Sub RunCompare()Call compareSheets("Before", "After")End SubSub compareSheets(shtBefore As String, shtAfter As String)Dim mycell As RangeDim 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 IfNextMsgBox mydiffs & " differences found", vbInformationActiveWorkbook.Sheets(shtAfter).SelectEnd Sub[/COLOR][/SIZE][/CODE]methanin gaththe <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /><img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /><a href="https://www.mrexcel.com/forum/excel-questions/484144-compare-two-sheets-highlight-differences-sheet-attached.html" target="_blank">https://www.mrexcel.com/forum/excel-questions/484144-compare-two-sheets-highlight-differences-sheet-attached.html</a></blockquote>

Verification: Hata thunen beduwama keeyada? (60 bedeema thuna)

Top Bottom