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.