I have a worksheet with 7 columns (C to I). I paste a large table from the internet into these columns and some of them are duplicates.
I would like to be able to run a macro to find the duplicate cells (in Column C) and move the duplicate rows (including the original row) from Columns C to I to the top of the list, moving the existing data down to make room. I want to be able to move just the rows in the 7 columns, not the entire row. I would also like to change the color of the duplicates to red but that is optional!
Can anyone tell me how to do this?
I would like to be able to run a macro to find the duplicate cells (in Column C) and move the duplicate rows (including the original row) from Columns C to I to the top of the list, moving the existing data down to make room. I want to be able to move just the rows in the 7 columns, not the entire row. I would also like to change the color of the duplicates to red but that is optional!
Can anyone tell me how to do this?