Creating a Loop to clear duplicate trades out of a Rec
Posted on 2013-11-06
Hi Guys, I need to create a Macro that can Loop down Column E find a Duplicate ID and cut and paste that line onto a different tab. The Duplicate ID must have a 0 or blank space in Column F so the correct ID is left behind. Below you see the column "FO MTM" has a blank space and 2 exact numbers in the "GBO ID" column, the 2nd row need to be cut and paste
to the Range ("P4").
Book Currency Trade ID GBO ID FO MTM GL MTM
GFALCOFRAM GBP 6530805 3811642.28 315,443 315,443
GFALCOFRAM GBP 6416721 3811642.28 315,443