The IF Function-right click on the comment to delete

[scowlfaceq02]

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.

[davesexcel]

are you able to delete the entire row?

[scowlfaceq02]

Yes I am able to delete the entire row.

[davesexcel]

I believe you need some kind of macro that will search the column and delete a row that meets some sort of criteria, is that something you would be considerring??

[Carim]

Hi,

My recommendation would be to use the Macro recorder as a test, for you to visualize the VBA translation of your daily operations ...
Then you could refine your macro to fully master your process ...

HTH
Carim