Monthly rollover of numbers

Hi,

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 *