New Yearly spreadsheet creation

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)

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

Works great thanks Riny