How How,
In which columns are the formulas? For e,g, there are formulas in all columns in sheet 2, but in sheet 1, column B is the only one which has a formula. On what bases(Criteria ) you wish to delete the rows?