I have a data set from a Pivot table, and I want to delete every row with a
blank underneath Total.

If you mean a copy of pivot, not a real pivot ..
Filter on that "Total" col, select blanks
Select filtered rows, right click Delete row
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---