Forum Discussion
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
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.
2 Replies
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
