I posted this over on Woody's, but haven't heard anything, and am under the gun to get an answer.
Please see attached. What I would like is a macro that would delete all the rows that have zero receipts for the total month of April 2011 (for example all of the rows for the month of April for the points Jeff and Sam would be deleted). On the other hand, if on any day during that period, there were receipts, none of rows for that point for the month of April 2011 would be deleted (for example John, Mary and Bill). Any ideas? Thanks in advance.
Bookmarks