AutoFilter lets you drill down to specific data you want to see. Additionally,
you can use it in VBA filter  for data you want to delete, which is ways faster
on long tables than looping through long tables.