Hi Moka,

I am not sure what you are dong and it is hard for anyone to understand when there is no data and a file to reference. Maybe post a workbook with the confidentiality removed.

Meanwhile, maybe something to look at is subtotals, also review hiding the rows you do not want added. The subtotal should automajically update depending on the "weeks" you want removed/hidden.

No matter how much I love VBA sometimes a formula is better and faster.