Identitying duplicates and Delete Lines

[999HelpPlease]

I have a very large document with duplicate information. I have a column of Invoice numbers with matches, a column of material numbers with matches, a column of dollar amounts with matches. The variable is that I have a column with Days On that has a variation in it. I need to match the first three and then for the last one I want to keep the highest number of Days On and delete all the other line it pertains to. My document is 10,000 lines so I don't want to do this manually. Is there a way to write this in VBA. I don't have anything started yet.

 

[Jake Blackmore]

I would go down the PivotTable route - very easy to select the criteria you need and then if you are still dead set on VBA afterworks you can easily work with the pivottable in VBA.

 

[Jon von der Heyden]

Can you post a small sample please?

 

[999HelpPlease]

I was able to do what I needed by doing a pivot table and then running VBA after it that was pretty simplified. Thank you for your suggestion.