Monthly rollover of numbers


I have an excel file with more than 100 sheets with same format.  I would like to copy current month numbers (range of sells) of selected sheets  and “paste speical values” to previous month’s section of the same sheet (range of sells beside curent month numbers).  I have to do this task  every month when starting a new month. How can I automate this function?


Appriciate your help.

Kind Regards




By: Christo

Leave a Reply

Your email address will not be published. Required fields are marked *