Hi I know this tittle makes little sense but here goes
so I ave a few macros that clear the many sheets have for new data entry. What I want to do is to have the macro auto save with a new name in another location.
I can get it all working but the after the auto save, the new save is opened...