Looking for a macro that when I run it will group rows with the same value in one column together. I have a list with part numbers and I want to be able to paste a new list at the bottom and when I run the Macro it will group them with common part numbers. I did this manually but I don't want to have to search each part individually I want to paste the new list to the bottom and just run the macro and it will group the rows with the same part number together.