PDA

View Full Version : Copy row to the duplicate row - Macro



james22
07-27-2010, 10:39 PM
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
07-27-2010, 11:12 PM
Which row gets copied over? The original or the duplicate?

james22
07-27-2010, 11:17 PM
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
07-28-2010, 01:17 AM
If u could provide Sample Data and how exactly u want the result..
It would be more clear to find solution.

james22
07-28-2010, 01:52 AM
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
07-29-2010, 02:04 AM
hey Khuhsi & Aussiebear.. looking to you for solution :)

khushii
07-29-2010, 02:08 AM
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..

"InputArea" = Sheet1!$A$3:$K$1048576

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

james22
08-04-2010, 04:04 AM
Hey Khushii.. That's awsome!! I appreciate your help