hi kelly,

fill an array with the values in column A
then loop through the cells in column A again, but this time checking
the number of occurances of the cells value in the array - if it occurs
twice then use cells(i,7) to copy the value over to H2,I2 etc

does this help, or do you need a complete answer?
Jason



Kelly******** wrote:

I need to compare data in column A (which contains Names) starting with cell
A2 if a nother cell in column A has the same name then copy cell G in that
row to H2 then repeat the search again and if another match to A2 is found
copy cell G in that row to I2
If no match is found do nothing
I would like to incorporate this into a macro and run it from another sheet
in the workbook