[reposting with clearer title]

Is there a way to create a macro that will do the following (I'm stating it as a person would do it):

- look down column A and find any two rows that match in column A only (if other columns differ across the rows that's okay)
Say it finds that row 10 and row 11 in column A match, then
- look across these two matching rows to column J and determine if row 10/column J differs from row 11/column J
- and if yes, they do differ, change row 10/column J to the contents of row 11/column J
- lastly, after making that change, continue on down column A to find additional changes needed until the whole spreadsheet is checked

If this is possible, please advise and maybe even provide the instructions or formula to use?

Thanks,
Cindi