I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are exact duplicates except the ID. Something like this:
Cells: A | B | C | D | E | Row1: 1 | 2016-08-12 | Support | filename221.png | 12458 | Row2: 2 | 2016-08-12 | Support | filename221.png | 12458 | Row3: 3 | 2016-08-13 | Support | filename223.png | 13354 | Row4: 4 | 2016-08-14 | Support | filename225.png | 13002 | Row5: 5 | 2016-08-14 | Support | filename225.png | 13002 | Row6: 6 | 2016-08-15 | Support | filename226.png | 10007 |
I want to find duplicate rows based on the contents in B, C, D & E columns. If all these contents are identical, then I should copy the content of A cells of all such duplicate rows to a new spreadsheet row.
Something like this:
Row1: 1,2 Row2: 4,5
Since the data is huge, would like to do it using a macro. Please help.
Find duplicate rows and copy content of one cell to new sheet