Excel Duplicate Code

[Justijb]

I know it may be a novice request and an even easier solution but I wanted to know what the VBA code would be to remove the duplicate in one column and its correlating data in other columns and only keep unique items. To explain:

I have a spreadsheet with 7 (A-G) columns with numbers in Column C and rows 1 - 5000. These numbers sometimes have duplicates. How do I remove the duplicates in Column C and place them in a new sheet with everything else in that row and only keep the unique numbers in Column C?

Hopefully I am explaining myself correctly. Any assistance would be very much appreciated

 

[JackDanIce]

If you have numbers 1, 1, 2, 3, 4, 4, 5 in column C

Do you want the existing sheet to keep rows with 1, 2, 3, 4 and 5 and move rows with 1 and 4 to the new sheet?

On a copy of your workbook, try recording a macro where you select the entire range, then used Data->Remove Duplicates apply to column C and see if that gives a starting point.