Gurus,
i'm comparing 2 sets of data like below:
is there a way to avoid the 2nd loop by some kind of function?
like I can simply just do something like this:
i'm comparing 2 sets of data like below:
VBA Code:
Sub ajsidjaisdjiadj()
for each cell1 in xxx
for each cell2 in xxx
if cell1 = cell2 then
...
else
...
end if
next cell2
next cell1
End Sub
is there a way to avoid the 2nd loop by some kind of function?
like I can simply just do something like this:
VBA Code:
Sub ajsidjaisdjiadj()
for each cell1 in xxx
if cell1.value belongs to 2nd table then
...
else
...
end if
next cell1
End Sub