software

Hai,

Im not a good excel user and i have a problem here, please any one.

i got sheet1 with 2 columns like this:

code | item
100 | book2
222 | paper1
101 | book1
333 | pen1

then i got sheet2 with 2 columns like this:

code | item
100 | book2
102 | book3
101 | book1

so i want to extract all possible item and code from sheet1 that match
the code in sheet2. I need to extract the match code and item into new
sheet3.

So for example after we extract the above data i will get sheet3 just
like this:

code | item
100 | book2
101 | book1

Can anyone please help me in this matter? any suggestion with VBA
programming or anything is accepted.

Please.

Thanks.--
sweetnet
------------------------------------------------------------------------
sweetnet's Profile: www.excelforum.com/member.php...oamp;userid=31809
View this thread: www.excelforum.com/showthread...hreadid=515318Try this code
The Following VBA procedure should do the trick for you.

Objective: Compare Values in Old Sheet With New Sheet. When differences are
found record the Number ... and what sheet it is and isn't on ... in a sheet
called quot;Differencesquot;.

NOTE :
1) You must make sure you have the 3 sheets name properly
2) Start Code by calling quot;FindSheetDiffquot;
Public Sub FindSheetDiff()
Call FindAndRecDiff(quot;Oldquot;, quot;Newquot;)
Call FindAndRecDiff(quot;Newquot;, quot;Oldquot;)
End SubPrivate Sub FindAndRecDiff(SourceSh, TargetSh)
With ThisWorkbook.Sheets(SourceSh)
For Each C In .Columns(quot;A:Aquot;).SpecialCells(xlCellTypeConstants, 3)
With ThisWorkbook.Sheets(TargetSh).Range(quot;A:Aquot;)
If .Find(C.Value, LookIn:=xlValues) Is Nothing Then

With ThisWorkbook.Sheets(quot;Differencequot;)
NxRw = .Cells(65536, 1).End(xlUp).Row 1
..Cells(NxRw, 1).Value = C.Value
..Cells(NxRw, 2).Value = quot;In quot; amp; SourceSh amp; quot; But not in quot; amp; TargetSh
End With

End If
End With
Next C
End With
End Sub

quot;sweetnetquot; wrote:

gt;
gt; Hai,
gt;
gt; Im not a good excel user and i have a problem here, please any one.
gt;
gt; i got sheet1 with 2 columns like this:
gt;
gt; code | item
gt; 100 | book2
gt; 222 | paper1
gt; 101 | book1
gt; 333 | pen1
gt;
gt; then i got sheet2 with 2 columns like this:
gt;
gt; code | item
gt; 100 | book2
gt; 102 | book3
gt; 101 | book1
gt;
gt; so i want to extract all possible item and code from sheet1 that match
gt; the code in sheet2. I need to extract the match code and item into new
gt; sheet3.
gt;
gt; So for example after we extract the above data i will get sheet3 just
gt; like this:
gt;
gt; code | item
gt; 100 | book2
gt; 101 | book1
gt;
gt; Can anyone please help me in this matter? any suggestion with VBA
gt; programming or anything is accepted.
gt;
gt; Please.
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; sweetnet
gt; ------------------------------------------------------------------------
gt; sweetnet's Profile: www.excelforum.com/member.php...oamp;userid=31809
gt; View this thread: www.excelforum.com/showthread...hreadid=515318
gt;
gt;