Copy row to the duplicate row - Macro

[james22]

Hi.. I have recently joined your forum. If anyone can crack this for me
Here is the sequence of functions that I am trying to do:

If there is any change in any row, search for duplicates in Column "B". If duplicate found then copy entire row (in which the change has been made), to this duplicate row.

There are 7 columns & number of rows can be different every time.

[Aussiebear]

Which row gets copied over? The original or the duplicate?

[james22]

Which row gets copied over? The original or the duplicate?

Thanks Aussiebear,

the original one in which the change has been made (& that change triggered the whole procedure) to be copied to the duplicate one. The idea is to have similar rows for duplicate values in Clolumn B.

[khushii]

If u could provide Sample Data and how exactly u want the result..
It would be more clear to find solution.

[james22]

If u could provide Sample Data and how exactly u want the result..
It would be more clear to find solution.

Thanks a ton Khushii..
Here is the attachment.

[james22]

hey Khuhsi & Aussiebear.. looking to you for solution

[khushii]

If there is any change in any row, search for duplicates in Column "B". If duplicate found then copy entire row (in which the change has been made), to this duplicate row.
.

Hi..here is my effort

Function works as the following sequence
If any row is changed, it searches for the Duplicate keywordID in Col B.
If duplicate found.. then it copies the changed Row to Duplicate Role..

[vba]"InputArea" = Sheet1!$A$3:$K$1048576 [/vba]

I m not VBA Expert..but still tried my best.
Hope it Helps

[james22]

Hey Khushii.. That's awsome!! I appreciate your help