Hello all,

I have spent most of the day looking for an Excel Macro solution for basically the same issue as in the linked OpenOffice forum below. I am OK at manually creating and modifying code I find around the net for my own purposes, but I am just not sure about the syntax differences between MS Office and OpenOffice. Any help to convert the solution provided would be great. I have just under 7000 lines in my file and my data goes from columns A to R where A is 'key' field (like in the linked example).

http://forum.openoffice.org/en/forum...hp?f=9&t=46068

Thank you for taking a look,
YSJ