I need to copy data that is duplicated in column A to a new sheet but need the entire row copied across as well, I was trying to use =VLOOKUP($A$1,'sheet2'!$A$5:$AY$789,COLUMN(A1),FALSE but that only copies the first row of those duplicated.


A B C D E F
1 Adelaide Brighton Cement Limited alsnvla;sndv 1 1 1 1
2 AGL Energy Services Pty Ltd asdv las v 2 2 2 2
3 AGL Energy Services Pty Ltd dslkbnlfg 1 1 1 1
4 Auscarbon Pty Ltd ds;bkmnblksng 3 3 3 3
5 Auscarbon Pty Ltd s;kdl; fkl 1 1 1 1