I would like to have an Excel macro which removes multiples of the same number and copies those rows over to a new sheet. The attached file shows an example.
Row 1 is the header row
Data begins from Row 2
Macro will prompt for which Column to look in
Macro will look in Col A (in this example) of Sheet 1 for any number which occurs more than one time. It will copy those rows and paste them in Sheet 3 starting in Row 2. The rows which have no multiples will be pasted on Sheet 2. Sheet 1 will retain the original data.Multiples.xlsm