Hi, Please try this macro. This macro will give reference of numbers that matches in D column i have inserted two columns in bwtween) with col A and also "true" and also a ref of A column next to D column. Confirm actualy what u want.(i have added 4or 6 numbers for examble) --R.Karunanithi
Sub Compare() Dim i As Integer Dim j As Integer For i = 2 To 36 For j = 2 To 40 If cells(i, 1).Value = cells(j, 4).Value Then cells(i, 2).Value = "True" cells(i, 3).Value = "Row" & j cells(j, 5).Value = "Row" & i End If Next j Next i End Sub --- On Wed, 7/6/11, HARI NAIR <hari.shrin...@gmail.com> wrote: From: HARI NAIR <hari.shrin...@gmail.com> Subject: $$Excel-Macros$$ marco to find common value To: excel-macros@googlegroups.com Date: Wednesday, July 6, 2011, 10:49 AM I want a marco to find common values of column A and B in column C in the attached file. Please Help. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
rk-xyz2harinair.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
