tzcoding
New Member
- Joined
- Mar 17, 2023
- Messages
- 8
- Office Version
- 2016
- Platform
- Windows
I need help getting this VBA code below to work automatically across multiple cells. I was using this formula before =IF(S6=Q6, "MATCH", "NOT MATCH") and just copying it down to the next cell below, but that's not efficient with a larger data set.
Help Need: I need the VBA code to look at a range from Column S6 to Column Q6933. See if they match and if so output to Column T the results (Match Or Not Match).
Help Need: I need the VBA code to look at a range from Column S6 to Column Q6933. See if they match and if so output to Column T the results (Match Or Not Match).
VBA Code:
Public Sub Shop_ID_Check()
If Range("S6").Value = Range("Q6").Value Then
Range("T6").Value = "MATCH"
Else
Range("T6").Value = "NOT MATCH"
End If
End Sub