Compare 2 columns of names and report
Closed
traveller20
-
Oct 21, 2010 at 05:09 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 21, 2010 at 07:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 21, 2010 at 07:41 AM
Related:
- Compare 2 columns of names and report
- Tentacle locker 2 - Download - Adult games
- My contacts list names - Guide
- Fnia 2 - Download - Adult games
- Ideogram ai names - Guide
- Euro truck simulator 2 download free full version pc - Download - Simulation
5 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 21, 2010 at 05:35 AM
Oct 21, 2010 at 05:35 AM
in sheet1 and sheet2 row 1 is having row headings.
in that case try this mcro
in that case try this mcro
Sub test() Dim r As Range, c As Range, dest As Range Dim cfind As Range, x As String With Worksheets("sheet1") Set r = Range(.Range("c2"), .Range("c2").End(xlDown)) For Each c In r x = c.Value With Worksheets("sheet2").Columns("c:c") Set cfind = .Cells.Find(what:=x, lookat:=xlWhole, LookIn:=xlValues) If cfind Is Nothing Then GoTo nextc cfind.EntireRow.Copy With Worksheets("sheet3") Set dest = .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) dest.PasteSpecial End With End With nextc: Next c End With End Sub
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 21, 2010 at 05:41 AM
Oct 21, 2010 at 05:41 AM
SORRY I forgot to add one important instruction
in sheet 1 and sheet 2 in c2 type the formula
=A2&B2
copy C2 down in both the sheets.
THEN ONLY RUN THE MACRO "TEST"
in sheet 1 and sheet 2 in c2 type the formula
=A2&B2
copy C2 down in both the sheets.
THEN ONLY RUN THE MACRO "TEST"
Didn't find the answer you are looking for?
Ask a question
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 21, 2010 at 07:41 AM
Oct 21, 2010 at 07:41 AM
the required information is copied to sheet 3. anyhow I shall modify the macro tomorrow morning