Delete Duplicated rows

http://help.lockergnome.com/office/d...ct1003548.html
above is cross-link to First post. Sorry I didn't find this forum first. I am somewhat green with everything but basic excel.
I have a spreadsheet with columns A through F. Column "C" is an invoice # and is listed multiple times, depending on the number of items billed on this invoice. I'm trying to delete all multiple copies of this invoice leaving only the first instance of each (the first entry has the total sale). I found a macro on a forum from a while back and it will delete my duplicate invoices if I insert my invoice # to Column "A", but it get's my other columns out of sync. I think this macro was written for a two column spreadsheet. Here is the Macro that almost works:

Please Login or Register  to view this content.

I'm not familiar enough with Macros to know how to adapt this. Any help would be greatly appreciated.
Marv

Try this amended macro

Please Login or Register  to view this content.

Hope this helps.