I am comparing data on two spreadsheets. One of the spreadsheets is trades from the previous day which I print out in soft copy and compare it to today's trades in Excel. I am required to delete the "comment" field for any fails which cleaned up the previous day, these are fails which were on the previous spreadsheet, but not on the current spreadsheet. To delete the comment field, I right click on the comment to delete, choose "delete" and "shift cells up." If there was a trade that was booked a new item may show up on the report. I then insert and blank cell and shift cells down.

Currently, I manually go into each 75-100 cells on the spreadsheet and make the necessary adjustment. I am trying to come up with an if formula that will tell me to shift cells up or down based upon the data. Any help would be greatly appreciated.