Deleting rows for duplicate data in few columns

Hello folks,

Hope you are doing good.

I am working on an excel sheet having 40 odd columns. I need to Delete the rows if 4 of the columns have same data but keep the first row.

Lets say I have below columns in excel
Account No
Account Name
Trust
Units
Price
Transaction date
Memo NO
and so on...

Now lets say there are 5 rown in the worksheet which have same data for Account No, Account Name, Units & Transaction date. I need to write a macro which will keep first row and delete rest of the four.

Any help will be greatly appriciated. I am using office 2003.

Many thanks.

Regards
Deepak

Hi, Try :-

Please Login or Register  to view this content.

Regards Mick

hey huys,

thanks a lot for replies.

I shall try these solutions and i am sure it would work.

many thanks.

Regards
Deepak