Column D has many work order numbers. Column L has sequence numbers. I would like vb code that will remove all rows except the ones with the highest sequence numbers. in the example sheet i would like to keep rows 6 and 7, delete all others. This is in a table and i would prefer the code to use header names as variables if possible. thank you in advance for any help you may provide.
below is a link to the spreadsheet.
Mr Excel - Google Drive
below is a link to the spreadsheet.
Mr Excel - Google Drive