See attached report. Each month we need to empty the cell "Grand Total
" on whatever row contains the word "Pending
" is located on. In the spreadsheet example, there are 7 cells to empty. To make it interesting, the example attached only shows January. Once February's data is added, then the "Grand Total" column moves one column to the right. to make room for the February data Same will happen when we add March and so on. Since I have 100 spreadsheets to remove this pending/Grand Total cell each month, is there a macro that can do this even as the spreadsheet grows? Thanks for any help!