Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare contents between sheets and identify matching values
i want a macro script to compare contents in first sheet first column
with the contents in second sheet first column. please assist. thanks, nanda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare contents between sheets and identify matching values
On Nov 3, 5:02 pm, nanda wrote:
i want a macro script to compare contents in first sheet first column with the contents in second sheet first column. please assist. thanks, nanda Try this...ofc there can be better options...but this shld also work For i = 1 To 100 For j = 1 To 100 If Worksheets(1).Cells(i, 1).Value = Worksheets(2).Cells(j, 1).Value Then 'do whatever if match is found Exit For End If Next j Next i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 sheets and copy matching data | Excel Programming | |||
Help on Matching and Copying Values In Two Different Sheets | Excel Programming | |||
Could someone please help me w/ matching the contents of each two sheets? | Excel Discussion (Misc queries) | |||
HOW DO I COMPARE TWO SHEETS AND IDENTIFY WHICH CELLS DIFFER | Excel Discussion (Misc queries) | |||
Macro to compare values and return exact matching value | Excel Programming |