Hello, I'm a novice user of vba and need assistance creating a macro to loop through rows of data and delete rows based on criteria in column C. This is a weekly report and on average has about 10k- 12k rows of data. There are centers/locations in column C (i.e. Charlotte, Chicago 1, Tulsa 5, etc). I want the macro to keep only the first 10 rows of data for each location and any other rows for that location needs to be deleted then move on to the next location and do the same, etc. If the location has less than 10 rows, then those rows will stay as is and not be deleted. Any assistance with this would be greatly appreciated.