Find duplicates in column B, keep value from first instance in A, and replace B:H

**votekinky06** · 03-31-2014, 07:56 AM

Title pretty much says it all. I need a macro that will find duplicates in column B, there will never be more than one duplicate for each row, and keep the value in A from the first occurrence, but replace B:H values with the values in the duplicate occurrence, then delete the duplicate occurrence. Given that I'm very much down to the wire on this one I have also posed this question in a thread in which I was trying to solve a similar problem here: http://www.mrexcel.com/forum/excel-q...ml#post3764393.

Been googling for awhile to no avail, help is appreciated!

**Marc L** · 03-31-2014, 08:16 AM

Better to clarify with an attached workbook with a source worksheet and an expected result worksheet …

**votekinky06** · 03-31-2014, 08:31 AM

Thanks for looking, here ya go!

Master Forum Sample Initial State.xlsm

This is a much shortened version for simplicity, there will usually be a couple of thousand rows and the number of rows will be variable.

Originally Posted by Marc L

Better to clarify with an attached workbook with a source worksheet and an expected result worksheet …

**Marc L** · 03-31-2014, 11:10 AM

Several ways to achieve it but this is the easy way to understand for beginner,
code to insert in the worksheet module :

Please Login or Register  to view this content.

**votekinky06** · 03-31-2014, 02:06 PM

Originally Posted by Marc L

Several ways to achieve it but this is the easy way to understand for beginner,
code to insert in the worksheet module :

Please Login or Register  to view this content.

Any way to change the paste range to where it doesn't paste past column H? I have data in K and L that I need to preserve.

**Marc L** · 03-31-2014, 04:04 PM

Just change the cells number to copy ‼

Please Login or Register  to view this content.

Find duplicates in column B, keep value from first instance in A, and replace B:H

LinkBack

Thread Tools

Rate This Thread

Display

Find duplicates in column B, keep value from first instance in A, and replace B:H

Re: Find duplicates in column B, keep value from first instance in A, and replace B:H

Re: Find duplicates in column B, keep value from first instance in A, and replace B:H

Try this !

Re: Try this !

Re: Find duplicates in column B, keep value from first instance in A, and replace B:H

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find and replace second instance

Need to find/replace a certain instance of number within column of formula.

[SOLVED] Find and Replace first instance of word Only

[SOLVED] find and replace for instance

Use Lookup Table to Find/Replace Every Instance of a String

Bookmarks

Bookmarks

Posting Permissions