I am trying to make a template for a document that will be updated every week, and I was wondering if there was a way to insert some values automatically depending on the value of a cell.
To explain, each file will be named dd-mmm-yy, and I want to reference what was in last week's file and the file from two weeks ago (to quickly track patterns and such). Most of these values are text, if that makes a difference.
Each week's file will be saved into the same folder.