Hi,

I have one excel sheet with lot of columns with huge data.I need macro that will check for duplicates in that sheet and load that duplicate
records with another sheet by specifying how many times its repeated.If it is repeated more than once then it should
display like this,Number of columns should be change daily for this sheet.


col1 col2 col3 col4 col5 col6 col7 col8 Repeated Times
a b c d e f g h 3