Can you attach a workbook after all the copying etc has been done and before you would run the code to delete the rows that have <11 in Column D.
All the sheets should have some info in it by then I assume.

Hi Joli,
I have attached a workbook after all the copying etc has been done and before the code to delete the rows. Notice on a few worksheets their is no data for Age = 10 or less. In this report their is nothing that is only 10 or less days in the data for Delayed Retirement Plans,No Advisable Assets and Delayed Transactions but eventually their will be so I need the script to include those worksheets.
The sheets for Extended Default Enroll Deadlin and Failed Default Enroll don't have an Age field so I don't need the them to be included in the script.
Hope this helps and thanks for all your effort. I feel confident that you will find a way to help me.
gbaker

Attached Files

JPM_Weekly_Exceptions_lessthan10test.xlsm (490.9 KB, 11 views)