I just start working with Macros and I chose to use it on a report that I create every week. The only thing is that every week I save it with a different name and chage the date. The macro works only if I edit and change the name of the worksheet. I am assuming there is an easier way to use the macro with different workbooks...Maybe is the way that I am saving it?

Please take in consideration that I am a biginer.

Thank you