I have created an Excel worksheet with a couple of macros, but whenever I copy it for another week's task, the macros seem to keep the old reference.
I checked ALT F11 and the panel shows another worksheet. How can I delete the old worksheet and have only the latest one?
Also, how can I make the current macros reference only the worksheet I am working on at the moment?
Thanks in advance!