Report

Copy sheet, change sheet name, change cell number, etc

Hello,
I am completely new to macros, so please forgive me upfront. Through online tutorials I was able to add a macro button and copy the sheet.
However, I am looking for a code to do a few more tasks I have been doing manually for the last few years on a spreadsheet. Each sheet is a separate year (i.e. 2015, 2016, etc).

Currently, manually, I take my latest year sheet and copy it. I rename the sheet for the next year. Then I change the year listed in cell A6 to reflect the new year. Then I preform a Find and Replace to search within my formulas to find the year of two years ago, and replace it with the last year.

So the goal of the macro is:
Copy sheet (i.e. 2018)
Rename new sheet to the next year (2018 (2) to 2019)
Change cell A6 to value of new sheet name (2018 to 2019)
Find & Replace past year (Find 2017 and replace with 2018)

Any help would be appreciated.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!