This works but I would like to incorporate code which automatically selects allsheets when the "macro button" activated. The number of sheets can vary month bymonth.Once selected then the "update macros" would also run.