here are the two macros. One inserts the dates into the spreadsheet, the other references those cells to filter to pivot by. However, I always error out when there was a holiday the previous week because there was no work done on that day. I need the second macro to just skip that .PivotItem if it doesn't exist. Is there a way to say, if none then skip?
Please Login or Register to view this content.
Bookmarks