macro to delete the second occurence

[bsmith27]

I am trying to make a macro that detects and then deletes the second copy of data in a spreadsheet. The data comes from the record of two identical tapes, so that the only thing that is different in the information of the second copy is the tape number. I need to identify the repeat using a sequence number and copy the that tape number beside the first instead of underneath.

please if anyone has any ideas so I can try and rig something, that would be very helpful.

[PaulMH]

Perhaps a sample of the data would make it easier to see your issue. I have done this many times in many different ways. If the data is normally unique enough a three column sort can line up the dups and then a formula entered in an inserted row that looks for dups and returns a 1 on the first and a 2 on the dup. The data can then be sorted on the inserted column and the dups fall to the bottom. This works well with smaller data sets or ones that only have to be cleaned once in a while. If this is a regular task, then code is the way to go.

Paul

[bsmith27]

This file show the before and after. scroll down to see that the second half is deleted.