Remove duplicate from rows from specific cell/row number to specific cell/row number

Hi,

I have the some data in sheet “DATA” where I have table with headings Tag, URM-1, URM-2, URM-3 etc.

Every tag contains multiple URM’s in each row.
Need vba code to remove duplicates contains from URM-1 to URM-7 only against “Tag” in individual rows and wants the result in new sheet “RESULT”

For example in sheet “DATA”

In row 2 against tag “JIOVNAU18349” there are three URMs. Against 3 URM 2 URMs are duplicate and one URM is Unique. Hence I want to keep the unique URM’s in ROW 2.

Do not remove duplicates in “Tag” Duplicates should be removed from Column URM-1 to URM-7. Please provide provision to change URM columns to remove duplicates. Means to remove duplicate urm from URM-1 to URM-7 OR URM-3 to URM-5, etc.

Please note I want the result in NEW SHEET.

this can do it

Please Login or Register  to view this content.

Kind regards
Leo

This should do

Please Login or Register  to view this content.

Hey Thank you so much for the code

hi can you please provide code for below thread.
http://www.excelforum.com/excel-prog...ml#post4285701