I m looking for macro which finds duplicates quickly in huge excel sheet based on some key column/s and either put the data in another sheet or highlight in that sheet only.

The key column can be a single column or multiple columns.