New Yearly spreadsheet creation

[JamieKnox1255]

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

[#2 · Accepted solution]

@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.

[#3]

Works great thanks Riny