Sub CompareColumns() Dim ws As Worksheet Dim rng1 As Range, rng2 As Range Dim i As Long ' Set your worksheet and ranges Set ws = ThisWorkbook.Sheets("Sheet1") Set rng1 = ws.Range("A1:A100") ' First range Set rng2 = ws.Range("B1:B100") ' Second range ' Loop through the ranges For i = 1 To rng1.Rows.Count If rng1.Cells(i, 1).Value rng2.Cells(i, 1).Value Then ' Highlight mismatched cells rng1.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 1 rng2.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 2 End If Next i MsgBox "Comparison complete!" End Sub
KYA FRIEGHT RCM KA HSN CODE ANNUAL RETURN ME JAYEGA OUTWARD ME?
Only for outward supply
Sir
Interested to purchase utility
VBA code is not available on telegram
Table Number 6 me 22-23 ka input claim kara hua hai
Ye 22-23 k input ka details yaha dena hai ya nhi. ?
6M
Ca mitra ki taraf se code mai bej deta hu
148 paid karke Mil jayega Kya Link Sir ?
You willing receive Software
@CAMitra24 VBA Coding Kidhar Hai but sir ? Aapne bola hai description me hai kidhar dikh to nhi raha hai
Zero nai hoga sir because GSTR2B se data araha hai
??
Sub CompareColumns()
Dim ws As Worksheet
Dim rng1 As Range, rng2 As Range
Dim i As Long
' Set your worksheet and ranges
Set ws = ThisWorkbook.Sheets("Sheet1")
Set rng1 = ws.Range("A1:A100") ' First range
Set rng2 = ws.Range("B1:B100") ' Second range
' Loop through the ranges
For i = 1 To rng1.Rows.Count
If rng1.Cells(i, 1).Value rng2.Cells(i, 1).Value Then
' Highlight mismatched cells
rng1.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 1
rng2.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 2
End If
Next i
MsgBox "Comparison complete!"
End Sub
👍
VBA Code not available
Already shared in Telegram channel
Sir ji koi link to do
Link in description
WhatsApp ke group ya telegram ke group link toh de do
Link in description
2b me tu 22-23 input b h tu oska difference kha dikhaye table 8 m
Table 6 column M
VBA code is not available on telegram