Move Duplicates

[longytravel]

Morning,

I am sure this will be very easy for you guys.....!!

Column A2 down has policy numbers
Column B2 down has customer names
Column C has a merged title - 90 degree text
Column D shows when compared to another list of policy numbers whether it is a duplicate or not (true or false ISNUMBER)

Column F2 to I2 down is the same for the second list of data

So, i have my true and false as to whether it is a duplicate or not i would now like it pull and create a table/list of all the 'trues' taking both the policy name and number to a a separate part of the sheet - say starting at k2

I would like the code for a button to do it all if possible?!

Thanks as ever

 

[tigeravatar]

longytravel,

Is the only column containing the True/False values in column D?
Or also in column I for data contained in F:I?
Regardless, do you just want columns A and B copied over?
If there are True/False values in column I, then do you also want columns F and G copied over for all true values in column D or just for true values in column I?
If there are True/False values in column I, then do you also want columns A and B copied over for all true values in column I or just for true values in column D?

~tigeravatar

 

[longytravel]

Thanks!

Moved things round slighty - the True and Falses are in C (for list 1) and H (for list 2)

The names/policy numbers are the same which column you use (C or H) as the two represents the names/policy numbers in both lists so it does not matter if i pull the policy number/names from A and B (list 1) or F and G (list 2)

In its easiest terms i would like in K2 all records from Columns A and B which have a 'True' in C

Hope that makes sense!!!

 

[tigeravatar]

longytravel,

Give the following a try:

Sub tgr()
    
    With ActiveSheet
        .UsedRange.AutoFilter 3, "true"
        .Range("A2", .Cells(Rows.Count, "B").End(xlUp)).Copy .[K2]
        .AutoFilterMode = False
    End With
    
End Sub

Hope that helps,
~tigeravatar

 

[longytravel]

Easy as that!
Top stuff!