i have a spread sheet which gets generated every week, so its not a workbook I keep.
Every week I sort the 6 row spreadsheet by number and then delete everything with cell C over 1500. There are numbers from 1 to infinity in this cell.
Is there a way to simply remove all rows with numbers over 1500? Remembering it would be something I eitehr have to configure to the generated workbook every day its generated, or operated by my own desktop workbook linking into this one?
Any help would be wonderful