New Yearly spreadsheet creation

I run 2 statistic spreadsheets where I get data from other sheets every year and need to know how I can create new spreadsheets every year using the same set up without having to re-do every formula

Formulas and Functions

Riny_van_Eekelen
Jan 25, 2022
JamieKnox1255 That depends on how these formulae are specific to the year you work with. If they, for instance, contain links to other files/sheets where the names contain the the year (like File-2021-stat1.xlsx), you could use Find & Replace (ctrl-H) and find all occurrences of 2021 and replace these by 2022 within a sheet or even in the entire workbook.
If this is not your case, please clarify what exactly you are dealing with.

Riny_van_Eekelen

Platinum Contributor

Jan 25, 2022

JamieKnox1255 That depends on how these formulae are specific to the year you work with. If they, for instance, contain links to other files/sheets where the names contain the the year (like File-2021-stat1.xlsx), you could use Find & Replace (ctrl-H) and find all occurrences of 2021 and replace these by 2022 within a sheet or even in the entire workbook.

If this is not your case, please clarify what exactly you are dealing with.

JamieKnox1255

Copper Contributor

Jan 25, 2022

Works great thanks Riny

Forum Discussion

New Yearly spreadsheet creation

Resources