View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chad[_8_] Chad[_8_] is offline
external usenet poster
 
Posts: 1
Default Copying and moving matching data problem

Hello,

As a new learner of VBA, I’m having a very hard time with this. I’
trying to see if any cells in columns 1 and 3 are duplicates of eac
other. If so, I need for the value of the cell in column 2, in th
same row, next to the matching cell in column 1, to be copied int
column 4, in the same row as the matching cell in Column 3. Column
will have more entries than column 3.

In example, this is what it the spreadsheet would look like befo

Acc # Name Acc# Name
163 Mark 597
744 Pam 917
682 Eric
917 Sara
597 Mike
753 Liz

And, hopefully, it will copy and paste the matching values of column
into column 4, so it would look like this:

Acc # Name Acc# Name
163 Mark 597 Mike
744 Pam 917 Sarah
682 Eric
917 Sara
597 Mike
753 Liz

The actual spreadsheet will be much longer. Thank you so much i
advance. I’m having a very hard time getting past this.

Cha

--
Message posted from http://www.ExcelForum.com